Product: | GMF - Process Manufacturing Financials |
---|---|
Description: | LC Adjustment details view will contain detailed information for each actual LC adjustment |
Implementation/DBA Data: | APPS.GMF_LC_ADJ_DETAILS_V |
SELECT NVL(SL.PARENT_SHIP_LINE_ID
, SL.SHIP_LINE_ID) PARENT_SHIP_LINE_ID
, A.ADJUSTMENT_NUM
, DECODE(A.ADJUSTMENT_NUM
, CL.ADJUSTMENT_NUM
, 'Y'
, DECODE(A.ADJUSTMENT_NUM
, TL.ADJUSTMENT_NUM
, 'Y'
, DECODE(SL.PARENT_SHIP_LINE_ID
, SL2.PARENT_SHIP_LINE_ID
, DECODE(A.ADJUSTMENT_NUM
, SL.ADJUSTMENT_NUM
, 'Y'
, 'N')
, DECODE(A.ADJUSTMENT_NUM
, SL2.ADJUSTMENT_NUM
, 'Y'
, 'N')))) AS CURRENT_ADJUSTMENT_FLAG
, A.SHIP_HEADER_ID
, SL.SHIP_LINE_GROUP_ID
, A.SHIP_LINE_ID
, M.MATCH_ID
, M.ADJ_GROUP_DATE
, M.FROM_PARENT_TABLE_NAME
, M.FROM_PARENT_TABLE_ID
, I.INVOICE_NUM
, I.INVOICE_DATE
, I.PARTY_ID
, I.PARTY_SITE_ID
, IL.LINE_NUMBER INVOICE_LINE_NUMBER
, ID.INVOICE_DISTRIBUTION_ID
, ID.AMOUNT INVOICE_DISTR_AMT
, I.INVOICE_CURRENCY_CODE
FROM AP_INVOICES_ALL I
, AP_INVOICE_LINES_ALL IL
, AP_INVOICE_DISTRIBUTIONS_ALL ID
, INL_MATCHES M
, INL_SHIP_LINES_ALL SL2
, INL_TAX_LINES TL
, INL_CHARGE_LINES CL
, INL_SHIP_LINES_ALL SLP
, INL_SHIP_LINES_ALL SL
, INL_ALLOCATIONS A
WHERE I.INVOICE_ID = IL.INVOICE_ID
AND IL.INVOICE_ID = ID.INVOICE_ID
AND IL.LINE_NUMBER = ID.INVOICE_LINE_NUMBER
AND ID.INVOICE_DISTRIBUTION_ID = M.FROM_PARENT_TABLE_ID
AND (M.MATCH_AMOUNT_ID = DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, CL.MATCH_AMOUNT_ID
, 'INL_TAX_LINES'
, TL.MATCH_AMOUNT_ID
, 'INL_SHIP_LINES'
, NULL
, NULL) OR M.MATCH_ID = DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, NULL
, 'INL_TAX_LINES'
, NULL
, 'INL_SHIP_LINES'
, DECODE(SL.PARENT_SHIP_LINE_ID
, SL2.PARENT_SHIP_LINE_ID
, SL.MATCH_ID
, SL2.MATCH_ID)
, NULL))
AND (SL.ADJUSTMENT_NUM <= A.ADJUSTMENT_NUM)
AND SL2.SHIP_LINE_ID (+) = DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, A.FROM_PARENT_TABLE_ID
, NULL)
AND TL.TAX_LINE_ID (+) = DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_TAX_LINES'
, A.FROM_PARENT_TABLE_ID
, NULL)
AND CL.CHARGE_LINE_ID (+) = DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_CHARGE_LINES'
, A.FROM_PARENT_TABLE_ID
, NULL)
AND SL.PARENT_SHIP_LINE_ID = SLP.PARENT_SHIP_LINE_ID
AND (SLP.ADJUSTMENT_NUM = SL.ADJUSTMENT_NUM OR SL2.ADJUSTMENT_NUM IS NOT NULL)
AND SLP.SHIP_LINE_ID = A.SHIP_LINE_ID
AND A.LANDED_COST_FLAG = 'Y'