AR_INVOICE_LINES

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
CUSTOMER_TRX_ID CUSTOMER_TRX_LINE_ID LINE_NUMBER LINE_TYPE ITEM_DESCRIPTION QUANTITY_ORDERED QUANTITY UNIT_OF_MEASURE_NAME ITEM_CODE UNIT_SELLING_PRICE EXTENDED_AMOUNT SALES_ORDER SALES_ORDER_DATE TAX_RATE VAT_TAX_ID TAX_EXEMPTION_ID PERCENT_EXEMPTION EXEMPTION_TYPE LOCATION_RATE_ID TAX_PRECEDENCE LINK_TO_CUST_TRX_LINE_ID TAX_EXISTS_FOR_THIS_LINE_FLAG ITEM_EXCEPTION_RATE_ID MEMO_LINE_SEQ_ID AUTORULE_DURATION_PROCESSED UOM_CODE DEFAULT_USSGL_TRANSACTION_CODE DEFAULT_USSGL_TRX_CODE_CONTEXT AUTOTAX LAST_PERIOD_TO_CREDIT ITEM_CONTEXT TAX_EXEMPT_FLAG TAX_EXEMPT_NUMBER TAX_EXEMPT_REASON_CODE TAX_VENDOR_RETURN_CODE LOCATION_SEGMENT_ID MOVEMENT_ID ORG_ID REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE RULE_START_DATE INITIAL_CUSTOMER_TRX_LINE_ID SALES_ORDER_SOURCE TAXABLE_FLAG REVENUE_AMOUNT AUTORULE_COMPLETE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN SET_OF_BOOKS_ID REASON_CODE INVENTORY_ITEM_ID PREVIOUS_CUSTOMER_TRX_ID PREVIOUS_CUSTOMER_TRX_LINE_ID QUANTITY_CREDITED UNIT_STANDARD_PRICE SALES_ORDER_REVISION SALES_ORDER_LINE ACCOUNTING_RULE_ID ACCOUNTING_RULE_DURATION GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 INTERFACE_LINE_CONTEXT INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE15 WH_UPDATE_DATE

Name

CUSTOMER_TRX_ID

CUSTOMER_TRX_LINE_ID

LINE_NUMBER

LINE_TYPE

ITEM_DESCRIPTION

QUANTITY_ORDERED

QUANTITY

UNIT_OF_MEASURE_NAME

ITEM_CODE

UNIT_SELLING_PRICE

EXTENDED_AMOUNT

SALES_ORDER

SALES_ORDER_DATE

TAX_RATE

VAT_TAX_ID

TAX_EXEMPTION_ID

PERCENT_EXEMPTION

EXEMPTION_TYPE

LOCATION_RATE_ID

TAX_PRECEDENCE

LINK_TO_CUST_TRX_LINE_ID

TAX_EXISTS_FOR_THIS_LINE_FLAG

ITEM_EXCEPTION_RATE_ID

MEMO_LINE_SEQ_ID

AUTORULE_DURATION_PROCESSED

UOM_CODE

DEFAULT_USSGL_TRANSACTION_CODE

DEFAULT_USSGL_TRX_CODE_CONTEXT

AUTOTAX

LAST_PERIOD_TO_CREDIT

ITEM_CONTEXT

TAX_EXEMPT_FLAG

TAX_EXEMPT_NUMBER

TAX_EXEMPT_REASON_CODE

TAX_VENDOR_RETURN_CODE

LOCATION_SEGMENT_ID

MOVEMENT_ID

ORG_ID

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

RULE_START_DATE

INITIAL_CUSTOMER_TRX_LINE_ID

SALES_ORDER_SOURCE

TAXABLE_FLAG

REVENUE_AMOUNT

AUTORULE_COMPLETE_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

SET_OF_BOOKS_ID

REASON_CODE

INVENTORY_ITEM_ID

PREVIOUS_CUSTOMER_TRX_ID

PREVIOUS_CUSTOMER_TRX_LINE_ID

QUANTITY_CREDITED

UNIT_STANDARD_PRICE

SALES_ORDER_REVISION

SALES_ORDER_LINE

ACCOUNTING_RULE_ID

ACCOUNTING_RULE_DURATION

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_CATEGORY

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

INTERFACE_LINE_CONTEXT

INTERFACE_LINE_ATTRIBUTE1

INTERFACE_LINE_ATTRIBUTE2

INTERFACE_LINE_ATTRIBUTE3

INTERFACE_LINE_ATTRIBUTE4

INTERFACE_LINE_ATTRIBUTE5

INTERFACE_LINE_ATTRIBUTE6

INTERFACE_LINE_ATTRIBUTE7

INTERFACE_LINE_ATTRIBUTE8

INTERFACE_LINE_ATTRIBUTE9

INTERFACE_LINE_ATTRIBUTE10

INTERFACE_LINE_ATTRIBUTE11

INTERFACE_LINE_ATTRIBUTE12

INTERFACE_LINE_ATTRIBUTE13

INTERFACE_LINE_ATTRIBUTE14

INTERFACE_LINE_ATTRIBUTE15

WH_UPDATE_DATE

Query

SQL_Statement
SELECT lines.customer_trx_id customer_trx_id, lines.customer_trx_line_id customer_trx_line_id, decode(lines2.line_number, NULL, lines.line_number, NULL) line_number, lines.line_type line_type, nvl(ar_invoice_sql_func_pub.get_description(lines.customer_trx_line_id), lines.description) item_description, nvl(lines.quantity_ordered, lines.quantity_invoiced) quantity_ordered, nvl(lines.quantity_invoiced, lines.quantity_credited) quantity, uom.unit_of_measure unit_of_measure_name, nvl(msi.global_attribute1, m.global_attribute1) item_code, nvl(lines.unit_selling_price, 0) unit_selling_price, lines.extended_amount extended_amount, lines.sales_order sales_order, lines.sales_order_date sales_order_date, lines.tax_rate tax_rate, lines.vat_tax_id vat_tax_id, lines.tax_exemption_id tax_exemption_id, decode(lines.tax_exemption_id, NULL, NULL, decode(lines.sales_tax_id, NULL, exempt.rate_modifier, NULL)) percent_exemption, decode(lines.tax_exemption_id, NULL, NULL, decode(lines.sales_tax_id, NULL, exempt.rate_modifier, NULL)) exemption_type, lines.sales_tax_id location_rate_id, lines.tax_precedence tax_precedence, lines.link_to_cust_trx_line_id link_to_cust_trx_line_id, ar_invoice_sql_func_pub.get_taxyn(lines.customer_trx_line_id) tax_exists_for_this_line_flag, lines.item_exception_rate_id, lines.memo_line_seq_id, lines.autorule_duration_processed, lines.uom_code, lines.default_ussgl_transaction_code, lines.default_ussgl_trx_code_context, lines.autotax, lines.last_period_to_credit, lines.item_context, lines.tax_exempt_flag, lines.tax_exempt_number, lines.tax_exempt_reason_code, lines.tax_vendor_return_code, lines.location_segment_id, lines.movement_id, lines.org_id, lines.request_id, lines.program_application_id, lines.program_id, lines.program_update_date, lines.rule_start_date, lines.initial_customer_trx_line_id, lines.sales_order_source, lines.taxable_flag, lines.revenue_amount, lines.autorule_complete_flag, lines.last_update_date, lines.last_updated_by, lines.creation_date, lines.created_by, lines.last_update_login, lines.set_of_books_id, lines.reason_code, lines.inventory_item_id, lines.previous_customer_trx_id, lines.previous_customer_trx_line_id, lines.quantity_credited, lines.unit_standard_price, lines.sales_order_revision, lines.sales_order_line, lines.accounting_rule_id, lines.accounting_rule_duration, lines.global_attribute1, lines.global_attribute2, lines.global_attribute3, lines.global_attribute4, lines.global_attribute5, lines.global_attribute6, lines.global_attribute7, lines.global_attribute8, lines.global_attribute9, lines.global_attribute10, lines.global_attribute11, lines.global_attribute12, lines.global_attribute13, lines.global_attribute14, lines.global_attribute15, lines.global_attribute16, lines.global_attribute17, lines.global_attribute18, lines.global_attribute19, lines.global_attribute20, lines.global_attribute_category, lines.attribute_category, lines.attribute1, lines.attribute2, lines.attribute3, lines.attribute4, lines.attribute5, lines.attribute6, lines.attribute7, lines.attribute8, lines.attribute9, lines.attribute10, lines.attribute11, lines.attribute12, lines.attribute13, lines.attribute14, lines.attribute15, lines.interface_line_context, lines.interface_line_attribute1, lines.interface_line_attribute2, lines.interface_line_attribute3, lines.interface_line_attribute4, lines.interface_line_attribute5, lines.interface_line_attribute6, lines.interface_line_attribute7, lines.interface_line_attribute8, lines.interface_line_attribute9, lines.interface_line_attribute10, lines.interface_line_attribute11, lines.interface_line_attribute12, lines.interface_line_attribute13, lines.interface_line_attribute14, lines.interface_line_attribute15, lines.wh_update_date FROM INV_UNITS_OF_MEASURE uom, EGP_SYSTEM_ITEMS msi, ar_memo_lines_all_b m, zx_exemptions exempt, ra_customer_trx_lines lines2, ra_customer_trx_lines lines, ra_cust_trx_types_all types, ra_customer_trx trx WHERE lines.link_to_cust_trx_line_id = lines2.customer_trx_line_id(+) AND trx.customer_trx_id = lines.customer_trx_id AND trx.complete_flag = 'Y' AND trx.cust_trx_type_seq_id = types.cust_trx_type_seq_id AND types.default_printing_option = 'PRI' AND lines.uom_code = uom.uom_code(+) AND exempt.tax_exemption_id(+) = lines.tax_exemption_id AND lines.inventory_item_id = msi.inventory_item_id(+) AND lines.memo_line_seq_id = m.memo_line_seq_id(+) AND lines.org_id = msi.organization_id(+)

SQL_Statement

SELECT lines.customer_trx_id customer_trx_id,

lines.customer_trx_line_id customer_trx_line_id,

decode(lines2.line_number, NULL, lines.line_number, NULL) line_number,

lines.line_type line_type,

nvl(ar_invoice_sql_func_pub.get_description(lines.customer_trx_line_id), lines.description) item_description,

nvl(lines.quantity_ordered, lines.quantity_invoiced) quantity_ordered,

nvl(lines.quantity_invoiced, lines.quantity_credited) quantity,

uom.unit_of_measure unit_of_measure_name,

nvl(msi.global_attribute1, m.global_attribute1) item_code,

nvl(lines.unit_selling_price, 0) unit_selling_price,

lines.extended_amount extended_amount,

lines.sales_order sales_order,

lines.sales_order_date sales_order_date,

lines.tax_rate tax_rate,

lines.vat_tax_id vat_tax_id,

lines.tax_exemption_id tax_exemption_id,

decode(lines.tax_exemption_id, NULL, NULL, decode(lines.sales_tax_id, NULL, exempt.rate_modifier, NULL)) percent_exemption,

decode(lines.tax_exemption_id, NULL, NULL, decode(lines.sales_tax_id, NULL, exempt.rate_modifier, NULL)) exemption_type,

lines.sales_tax_id location_rate_id,

lines.tax_precedence tax_precedence,

lines.link_to_cust_trx_line_id link_to_cust_trx_line_id,

ar_invoice_sql_func_pub.get_taxyn(lines.customer_trx_line_id) tax_exists_for_this_line_flag,

lines.item_exception_rate_id,

lines.memo_line_seq_id,

lines.autorule_duration_processed,

lines.uom_code,

lines.default_ussgl_transaction_code,

lines.default_ussgl_trx_code_context,

lines.autotax,

lines.last_period_to_credit,

lines.item_context,

lines.tax_exempt_flag,

lines.tax_exempt_number,

lines.tax_exempt_reason_code,

lines.tax_vendor_return_code,

lines.location_segment_id,

lines.movement_id,

lines.org_id,

lines.request_id,

lines.program_application_id,

lines.program_id,

lines.program_update_date,

lines.rule_start_date,

lines.initial_customer_trx_line_id,

lines.sales_order_source,

lines.taxable_flag,

lines.revenue_amount,

lines.autorule_complete_flag,

lines.last_update_date,

lines.last_updated_by,

lines.creation_date,

lines.created_by,

lines.last_update_login,

lines.set_of_books_id,

lines.reason_code,

lines.inventory_item_id,

lines.previous_customer_trx_id,

lines.previous_customer_trx_line_id,

lines.quantity_credited,

lines.unit_standard_price,

lines.sales_order_revision,

lines.sales_order_line,

lines.accounting_rule_id,

lines.accounting_rule_duration,

lines.global_attribute1,

lines.global_attribute2,

lines.global_attribute3,

lines.global_attribute4,

lines.global_attribute5,

lines.global_attribute6,

lines.global_attribute7,

lines.global_attribute8,

lines.global_attribute9,

lines.global_attribute10,

lines.global_attribute11,

lines.global_attribute12,

lines.global_attribute13,

lines.global_attribute14,

lines.global_attribute15,

lines.global_attribute16,

lines.global_attribute17,

lines.global_attribute18,

lines.global_attribute19,

lines.global_attribute20,

lines.global_attribute_category,

lines.attribute_category,

lines.attribute1,

lines.attribute2,

lines.attribute3,

lines.attribute4,

lines.attribute5,

lines.attribute6,

lines.attribute7,

lines.attribute8,

lines.attribute9,

lines.attribute10,

lines.attribute11,

lines.attribute12,

lines.attribute13,

lines.attribute14,

lines.attribute15,

lines.interface_line_context,

lines.interface_line_attribute1,

lines.interface_line_attribute2,

lines.interface_line_attribute3,

lines.interface_line_attribute4,

lines.interface_line_attribute5,

lines.interface_line_attribute6,

lines.interface_line_attribute7,

lines.interface_line_attribute8,

lines.interface_line_attribute9,

lines.interface_line_attribute10,

lines.interface_line_attribute11,

lines.interface_line_attribute12,

lines.interface_line_attribute13,

lines.interface_line_attribute14,

lines.interface_line_attribute15,

lines.wh_update_date

FROM INV_UNITS_OF_MEASURE uom,

EGP_SYSTEM_ITEMS msi,

ar_memo_lines_all_b m,

zx_exemptions exempt,

ra_customer_trx_lines lines2,

ra_customer_trx_lines lines,

ra_cust_trx_types_all types,

ra_customer_trx trx

WHERE lines.link_to_cust_trx_line_id = lines2.customer_trx_line_id(+)

AND trx.customer_trx_id = lines.customer_trx_id

AND trx.complete_flag = 'Y'

AND trx.cust_trx_type_seq_id = types.cust_trx_type_seq_id

AND types.default_printing_option = 'PRI'

AND lines.uom_code = uom.uom_code(+)

AND exempt.tax_exemption_id(+) = lines.tax_exemption_id

AND lines.inventory_item_id = msi.inventory_item_id(+)

AND lines.memo_line_seq_id = m.memo_line_seq_id(+)

AND lines.org_id = msi.organization_id(+)