VIEW: APPS.RA_CUSTOMER_TRX_LINES_RA_V

Source

View Text - Preformatted

SELECT /* $Header: artrx.odf 120.167.12010000.20 2009/01/27 14:33:01 ankuagar ship $ */ CTL.ROWID , CTL.CUSTOMER_TRX_LINE_ID , CTL.CUSTOMER_TRX_ID , CTL.LINK_TO_CUST_TRX_LINE_ID , CTL.PREVIOUS_CUSTOMER_TRX_ID , CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID , CTL.INITIAL_CUSTOMER_TRX_LINE_ID , CTL.LINE_NUMBER , CTL.LINE_TYPE , CTL.DESCRIPTION , CTL.QUANTITY_ORDERED , CTL.QUANTITY_CREDITED , CTL.QUANTITY_INVOICED , NVL(CTL.QUANTITY_CREDITED, CTL.QUANTITY_INVOICED) , CTL.UNIT_STANDARD_PRICE , CTL.UNIT_SELLING_PRICE , CTL.EXTENDED_AMOUNT , CTL.REVENUE_AMOUNT , NVL(CTL.GROSS_EXTENDED_AMOUNT, CTL.EXTENDED_AMOUNT) , NVL(CTL.GROSS_UNIT_SELLING_PRICE, CTL.UNIT_SELLING_PRICE) , NVL(CTL.AMOUNT_INCLUDES_TAX_FLAG, 'DEFAULT') , CTL.UOM_CODE , CTL.REASON_CODE , CTL.ACCOUNTING_RULE_ID , CTL.ACCOUNTING_RULE_DURATION , CTL.RULE_START_DATE , CTL.AUTORULE_COMPLETE_FLAG , CTL.AUTORULE_DURATION_PROCESSED , CTL.LAST_PERIOD_TO_CREDIT , CTL.ITEM_CONTEXT , CTL.INVENTORY_ITEM_ID , CTL.MEMO_LINE_ID , CTL.TAXABLE_FLAG , CTL.TAX_PRECEDENCE , CTL.TAX_RATE , CTL.ITEM_EXCEPTION_RATE_ID , CTL.TAX_EXEMPTION_ID , CTL.TAX_EXEMPT_FLAG , CTL.TAX_EXEMPT_NUMBER , CTL.TAX_EXEMPT_REASON_CODE , CTL.TAX_VENDOR_RETURN_CODE , CTL.SALES_TAX_ID , CTL.LOCATION_SEGMENT_ID , CTL.VAT_TAX_ID , CTL.AUTOTAX , CTL.SET_OF_BOOKS_ID , CTL.SALES_ORDER_SOURCE , CTL.SALES_ORDER , CTL.SALES_ORDER_REVISION , CTL.SALES_ORDER_LINE , CTL.SALES_ORDER_DATE , CTL.MOVEMENT_ID , CTL.LAST_UPDATE_DATE , CTL.LAST_UPDATED_BY , CTL.CREATION_DATE , CTL.CREATED_BY , CTL.LAST_UPDATE_LOGIN , CTL.REQUEST_ID , CTL.PROGRAM_APPLICATION_ID , CTL.PROGRAM_ID , CTL.PROGRAM_UPDATE_DATE , CTL.DEFAULT_USSGL_TRANSACTION_CODE , CTL.DEFAULT_USSGL_TRX_CODE_CONTEXT , CTL.INTERFACE_LINE_CONTEXT , CTL.INTERFACE_LINE_ATTRIBUTE1 , CTL.INTERFACE_LINE_ATTRIBUTE2 , CTL.INTERFACE_LINE_ATTRIBUTE3 , CTL.INTERFACE_LINE_ATTRIBUTE4 , CTL.INTERFACE_LINE_ATTRIBUTE5 , CTL.INTERFACE_LINE_ATTRIBUTE6 , CTL.INTERFACE_LINE_ATTRIBUTE7 , CTL.INTERFACE_LINE_ATTRIBUTE8 , CTL.INTERFACE_LINE_ATTRIBUTE9 , CTL.INTERFACE_LINE_ATTRIBUTE10 , CTL.INTERFACE_LINE_ATTRIBUTE11 , CTL.INTERFACE_LINE_ATTRIBUTE12 , CTL.INTERFACE_LINE_ATTRIBUTE13 , CTL.INTERFACE_LINE_ATTRIBUTE14 , CTL.INTERFACE_LINE_ATTRIBUTE15 , CTL.ATTRIBUTE_CATEGORY , CTL.ATTRIBUTE1 , CTL.ATTRIBUTE2 , CTL.ATTRIBUTE3 , CTL.ATTRIBUTE4 , CTL.ATTRIBUTE5 , CTL.ATTRIBUTE6 , CTL.ATTRIBUTE7 , CTL.ATTRIBUTE8 , CTL.ATTRIBUTE9 , CTL.ATTRIBUTE10 , CTL.ATTRIBUTE11 , CTL.ATTRIBUTE12 , CTL.ATTRIBUTE13 , CTL.ATTRIBUTE14 , CTL.ATTRIBUTE15 , CTL.WAREHOUSE_ID , CTL.GLOBAL_ATTRIBUTE_CATEGORY , CTL.GLOBAL_ATTRIBUTE1 , CTL.GLOBAL_ATTRIBUTE2 , CTL.GLOBAL_ATTRIBUTE3 , CTL.GLOBAL_ATTRIBUTE4 , CTL.GLOBAL_ATTRIBUTE5 , CTL.GLOBAL_ATTRIBUTE6 , CTL.GLOBAL_ATTRIBUTE7 , CTL.GLOBAL_ATTRIBUTE8 , CTL.GLOBAL_ATTRIBUTE9 , CTL.GLOBAL_ATTRIBUTE10 , CTL.GLOBAL_ATTRIBUTE11 , CTL.GLOBAL_ATTRIBUTE12 , CTL.GLOBAL_ATTRIBUTE13 , CTL.GLOBAL_ATTRIBUTE14 , CTL.GLOBAL_ATTRIBUTE15 , CTL.GLOBAL_ATTRIBUTE16 , CTL.GLOBAL_ATTRIBUTE17 , CTL.GLOBAL_ATTRIBUTE18 , CTL.GLOBAL_ATTRIBUTE19 , CTL.GLOBAL_ATTRIBUTE20 , MC.CATEGORY_ID , MC.DESCRIPTION , RULES.NAME FROM MTL_CATEGORIES MC, MTL_ITEM_CATEGORIES MIC, RA_CUSTOMER_TRX_LINES CTL, RA_CUSTOMER_TRX CT, RA_CUST_TRX_TYPES CTT, RA_RULES RULES WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID AND CTT.TYPE <> 'GUAR' AND CTL.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+) AND MIC.CATEGORY_SET_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.CATEGORY_SET_ID AND MIC.ORGANIZATION_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.INV_ORG_ID AND MIC.CATEGORY_ID = MC.CATEGORY_ID(+) AND CTL.LINE_TYPE = 'LINE' AND CTL.ACCOUNTING_RULE_ID = RULES.RULE_ID (+)

View Text - HTML Formatted

SELECT /* $HEADER: ARTRX.ODF 120.167.12010000.20 2009/01/27 14:33:01 ANKUAGAR SHIP $ */ CTL.ROWID
, CTL.CUSTOMER_TRX_LINE_ID
, CTL.CUSTOMER_TRX_ID
, CTL.LINK_TO_CUST_TRX_LINE_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.LINE_NUMBER
, CTL.LINE_TYPE
, CTL.DESCRIPTION
, CTL.QUANTITY_ORDERED
, CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED
, NVL(CTL.QUANTITY_CREDITED
, CTL.QUANTITY_INVOICED)
, CTL.UNIT_STANDARD_PRICE
, CTL.UNIT_SELLING_PRICE
, CTL.EXTENDED_AMOUNT
, CTL.REVENUE_AMOUNT
, NVL(CTL.GROSS_EXTENDED_AMOUNT
, CTL.EXTENDED_AMOUNT)
, NVL(CTL.GROSS_UNIT_SELLING_PRICE
, CTL.UNIT_SELLING_PRICE)
, NVL(CTL.AMOUNT_INCLUDES_TAX_FLAG
, 'DEFAULT')
, CTL.UOM_CODE
, CTL.REASON_CODE
, CTL.ACCOUNTING_RULE_ID
, CTL.ACCOUNTING_RULE_DURATION
, CTL.RULE_START_DATE
, CTL.AUTORULE_COMPLETE_FLAG
, CTL.AUTORULE_DURATION_PROCESSED
, CTL.LAST_PERIOD_TO_CREDIT
, CTL.ITEM_CONTEXT
, CTL.INVENTORY_ITEM_ID
, CTL.MEMO_LINE_ID
, CTL.TAXABLE_FLAG
, CTL.TAX_PRECEDENCE
, CTL.TAX_RATE
, CTL.ITEM_EXCEPTION_RATE_ID
, CTL.TAX_EXEMPTION_ID
, CTL.TAX_EXEMPT_FLAG
, CTL.TAX_EXEMPT_NUMBER
, CTL.TAX_EXEMPT_REASON_CODE
, CTL.TAX_VENDOR_RETURN_CODE
, CTL.SALES_TAX_ID
, CTL.LOCATION_SEGMENT_ID
, CTL.VAT_TAX_ID
, CTL.AUTOTAX
, CTL.SET_OF_BOOKS_ID
, CTL.SALES_ORDER_SOURCE
, CTL.SALES_ORDER
, CTL.SALES_ORDER_REVISION
, CTL.SALES_ORDER_LINE
, CTL.SALES_ORDER_DATE
, CTL.MOVEMENT_ID
, CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
, CTL.LAST_UPDATE_LOGIN
, CTL.REQUEST_ID
, CTL.PROGRAM_APPLICATION_ID
, CTL.PROGRAM_ID
, CTL.PROGRAM_UPDATE_DATE
, CTL.DEFAULT_USSGL_TRANSACTION_CODE
, CTL.DEFAULT_USSGL_TRX_CODE_CONTEXT
, CTL.INTERFACE_LINE_CONTEXT
, CTL.INTERFACE_LINE_ATTRIBUTE1
, CTL.INTERFACE_LINE_ATTRIBUTE2
, CTL.INTERFACE_LINE_ATTRIBUTE3
, CTL.INTERFACE_LINE_ATTRIBUTE4
, CTL.INTERFACE_LINE_ATTRIBUTE5
, CTL.INTERFACE_LINE_ATTRIBUTE6
, CTL.INTERFACE_LINE_ATTRIBUTE7
, CTL.INTERFACE_LINE_ATTRIBUTE8
, CTL.INTERFACE_LINE_ATTRIBUTE9
, CTL.INTERFACE_LINE_ATTRIBUTE10
, CTL.INTERFACE_LINE_ATTRIBUTE11
, CTL.INTERFACE_LINE_ATTRIBUTE12
, CTL.INTERFACE_LINE_ATTRIBUTE13
, CTL.INTERFACE_LINE_ATTRIBUTE14
, CTL.INTERFACE_LINE_ATTRIBUTE15
, CTL.ATTRIBUTE_CATEGORY
, CTL.ATTRIBUTE1
, CTL.ATTRIBUTE2
, CTL.ATTRIBUTE3
, CTL.ATTRIBUTE4
, CTL.ATTRIBUTE5
, CTL.ATTRIBUTE6
, CTL.ATTRIBUTE7
, CTL.ATTRIBUTE8
, CTL.ATTRIBUTE9
, CTL.ATTRIBUTE10
, CTL.ATTRIBUTE11
, CTL.ATTRIBUTE12
, CTL.ATTRIBUTE13
, CTL.ATTRIBUTE14
, CTL.ATTRIBUTE15
, CTL.WAREHOUSE_ID
, CTL.GLOBAL_ATTRIBUTE_CATEGORY
, CTL.GLOBAL_ATTRIBUTE1
, CTL.GLOBAL_ATTRIBUTE2
, CTL.GLOBAL_ATTRIBUTE3
, CTL.GLOBAL_ATTRIBUTE4
, CTL.GLOBAL_ATTRIBUTE5
, CTL.GLOBAL_ATTRIBUTE6
, CTL.GLOBAL_ATTRIBUTE7
, CTL.GLOBAL_ATTRIBUTE8
, CTL.GLOBAL_ATTRIBUTE9
, CTL.GLOBAL_ATTRIBUTE10
, CTL.GLOBAL_ATTRIBUTE11
, CTL.GLOBAL_ATTRIBUTE12
, CTL.GLOBAL_ATTRIBUTE13
, CTL.GLOBAL_ATTRIBUTE14
, CTL.GLOBAL_ATTRIBUTE15
, CTL.GLOBAL_ATTRIBUTE16
, CTL.GLOBAL_ATTRIBUTE17
, CTL.GLOBAL_ATTRIBUTE18
, CTL.GLOBAL_ATTRIBUTE19
, CTL.GLOBAL_ATTRIBUTE20
, MC.CATEGORY_ID
, MC.DESCRIPTION
, RULES.NAME
FROM MTL_CATEGORIES MC
, MTL_ITEM_CATEGORIES MIC
, RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CT
, RA_CUST_TRX_TYPES CTT
, RA_RULES RULES
WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND CTT.TYPE <> 'GUAR'
AND CTL.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
AND MIC.CATEGORY_SET_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.CATEGORY_SET_ID
AND MIC.ORGANIZATION_ID(+) = AR_REVENUE_ADJUSTMENT_PVT.INV_ORG_ID
AND MIC.CATEGORY_ID = MC.CATEGORY_ID(+)
AND CTL.LINE_TYPE = 'LINE'
AND CTL.ACCOUNTING_RULE_ID = RULES.RULE_ID (+)