View: AR_INVOICE_LINES_V

Product:	AR - Receivables
Description:	Collects invoice line item information
Implementation/DBA Data:	APPS.AR_INVOICE_LINES_V

View Text

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
, VAT.PRINTED_TAX_NAME PRINTED_TAX_NAME
, LINES.TAX_EXEMPTION_ID TAX_EXEMPTION_ID
, DECODE(LINES.TAX_EXEMPTION_ID
, NULL
, NULL
, DECODE(LINES.SALES_TAX_ID
, NULL
, EXEMPT.PERCENT_EXEMPT
, NULL )) PERCENT_EXEMPTION
, DECODE(LINES.TAX_EXEMPTION_ID
, NULL
, NULL
, DECODE(LINES.SALES_TAX_ID
, NULL
, EXEMPT.EXEMPTION_TYPE
, 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_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 MTL_UNITS_OF_MEASURE UOM
, MTL_SYSTEM_ITEMS MSI
, RA_TAX_EXEMPTIONS EXEMPT
, AR_VAT_TAX_VL VAT
, AR_MEMO_LINES M
, RA_CUSTOMER_TRX_LINES LINES2
, RA_CUSTOMER_TRX_LINES LINES
, RA_CUST_TRX_TYPES 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_ID = TYPES.CUST_TRX_TYPE_ID
AND TYPES.DEFAULT_PRINTING_OPTION = 'PRI' AND LINES.UOM_CODE = UOM.UOM_CODE(+) AND EXEMPT.TAX_EXEMPTION_ID(+) = LINES.TAX_EXEMPTION_ID AND VAT.VAT_TAX_ID(+) = LINES.VAT_TAX_ID
AND LINES.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND LINES.MEMO_LINE_ID = M.MEMO_LINE_ID(+) AND LINES.ORG_ID = MSI.ORGANIZATION_ID(+)

Columns