FND Design Data [Home] [Help]

View: AP_EXTRACT_INVOICE_DTLS_BC_V

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.AP_EXTRACT_INVOICE_DTLS_BC_V
View Text

SELECT AID.BC_EVENT_ID
, AID.INVOICE_DISTRIBUTION_ID
, AIL.DEFERRED_ACCTG_FLAG
, AIL.DEF_ACCTG_START_DATE
, AIL.DEF_ACCTG_END_DATE
, AIL.DEF_ACCTG_PERIOD_TYPE
, AIL.DEF_ACCTG_NUMBER_OF_PERIODS
, AID.INVOICE_DISTRIBUTION_ID
, 'N'
, AID.ACCOUNTING_DATE
, AID.AMOUNT
, AID.ASSETS_TRACKING_FLAG
, AID.ATTRIBUTE_CATEGORY
, AID.ATTRIBUTE1
, AID.ATTRIBUTE10
, AID.ATTRIBUTE11
, AID.ATTRIBUTE12
, AID.ATTRIBUTE13
, AID.ATTRIBUTE14
, AID.ATTRIBUTE15
, AID.ATTRIBUTE2
, AID.ATTRIBUTE3
, AID.ATTRIBUTE4
, AID.ATTRIBUTE5
, AID.ATTRIBUTE6
, AID.ATTRIBUTE7
, AID.ATTRIBUTE8
, AID.ATTRIBUTE9
, AID.AWARD_ID
, AID.DESCRIPTION
, AID.DIST_CODE_COMBINATION_ID
, AID.DISTRIBUTION_LINE_NUMBER
, AID.EXPENDITURE_ITEM_DATE
, AID.EXPENDITURE_TYPE
, AID.INCOME_TAX_REGION
, AID.MERCHANT_DOCUMENT_NUMBER
, AID.MERCHANT_REFERENCE
, AID.MERCHANT_TAX_REG_NUMBER
, AID.MERCHANT_TAXPAYER_ID
, AID.PERIOD_NAME
, AID.REFERENCE_1
, AID.REFERENCE_2
, AID.STAT_AMOUNT
, AID.TAX_RECOVERABLE_FLAG
, AID.TYPE_1099
, AWTG.NAME
, AIL.LINE_TYPE_LOOKUP_CODE
, AIL.DESCRIPTION
, AIL.LINE_SOURCE
, AIL.LINE_GROUP_NUMBER
, AIL.ITEM_DESCRIPTION
, AIL.ACCOUNT_SEGMENT
, AIL.BALANCING_SEGMENT
, AIL.COST_CENTER_SEGMENT
, AIL.OVERLAY_DIST_CODE_CONCAT
, AIL.DEFAULT_DIST_CCID
, AIL.ASSET_BOOK_TYPE_CODE
, AIL.EXPENSE_GROUP
, AIL.MERCHANT_NAME
, AIL.ATTRIBUTE_CATEGORY
, AIL.ATTRIBUTE1
, AIL.ATTRIBUTE2
, AIL.ATTRIBUTE3
, AIL.ATTRIBUTE4
, AIL.ATTRIBUTE5
, AIL.ATTRIBUTE6
, AIL.ATTRIBUTE7
, AIL.ATTRIBUTE8
, AIL.ATTRIBUTE9
, AIL.ATTRIBUTE10
, AIL.ATTRIBUTE11
, AIL.ATTRIBUTE12
, AIL.ATTRIBUTE13
, AIL.ATTRIBUTE14
, AIL.ATTRIBUTE15
, AIL.GLOBAL_ATTRIBUTE_CATEGORY
, AIL.GLOBAL_ATTRIBUTE1
, AIL.GLOBAL_ATTRIBUTE2
, AIL.GLOBAL_ATTRIBUTE3
, AIL.GLOBAL_ATTRIBUTE4
, AIL.GLOBAL_ATTRIBUTE5
, AIL.GLOBAL_ATTRIBUTE6
, AIL.GLOBAL_ATTRIBUTE7
, AIL.GLOBAL_ATTRIBUTE8
, AIL.GLOBAL_ATTRIBUTE9
, AIL.GLOBAL_ATTRIBUTE10
, AIL.GLOBAL_ATTRIBUTE11
, AIL.GLOBAL_ATTRIBUTE12
, AIL.GLOBAL_ATTRIBUTE13
, AIL.GLOBAL_ATTRIBUTE14
, AIL.GLOBAL_ATTRIBUTE15
, AIL.GLOBAL_ATTRIBUTE16
, AIL.GLOBAL_ATTRIBUTE17
, AIL.GLOBAL_ATTRIBUTE18
, AIL.GLOBAL_ATTRIBUTE19
, AIL.GLOBAL_ATTRIBUTE20
, AIL.SUMMARY_TAX_LINE_ID
, AID.ASSETS_ADDITION_FLAG
, AID.LINE_TYPE_LOOKUP_CODE
, AID.RATE_VAR_CODE_COMBINATION_ID
, AID.REVERSAL_FLAG
, AID.GLOBAL_ATTRIBUTE_CATEGORY
, AID.GLOBAL_ATTRIBUTE1
, AID.GLOBAL_ATTRIBUTE2
, AID.GLOBAL_ATTRIBUTE3
, AID.GLOBAL_ATTRIBUTE4
, AID.GLOBAL_ATTRIBUTE5
, AID.GLOBAL_ATTRIBUTE6
, AID.GLOBAL_ATTRIBUTE7
, AID.GLOBAL_ATTRIBUTE8
, AID.GLOBAL_ATTRIBUTE9
, AID.GLOBAL_ATTRIBUTE10
, AID.GLOBAL_ATTRIBUTE11
, AID.GLOBAL_ATTRIBUTE12
, AID.GLOBAL_ATTRIBUTE13
, AID.GLOBAL_ATTRIBUTE14
, AID.GLOBAL_ATTRIBUTE15
, AID.GLOBAL_ATTRIBUTE16
, AID.GLOBAL_ATTRIBUTE17
, AID.GLOBAL_ATTRIBUTE18
, AID.GLOBAL_ATTRIBUTE19
, AID.GLOBAL_ATTRIBUTE20
, AID.CANCELLATION_FLAG
, AID.INVOICE_LINE_NUMBER
, AID.INVOICE_DISTRIBUTION_ID
, AID.PARENT_REVERSAL_ID
, AID.AWT_FLAG
, -1
, AID.DETAIL_TAX_DIST_ID
, 'N'
, -1
, AWT_RELATED_IDS.DIST_CODE_COMBINATION_ID AWT_RELATED_DIST_CCID
, NVL(AIL.BASE_AMOUNT
, AIL.AMOUNT)
, AIL.AMOUNT
, NVL(AID.ROUNDING_AMT
, 0)
, NVL(AID.BASE_AMOUNT
, AID.AMOUNT)
, (NVL(AID.BASE_AMOUNT
, AID.AMOUNT) - NVL(AID.ROUNDING_AMT
, 0))
, 'AP_INV_DIST'
, AID.PO_DISTRIBUTION_ID
, 200
, 'AP_INV_DIST'
, 'AP_INVOICES'
, AID.INVOICE_DISTRIBUTION_ID
, AID.INVOICE_ID
, DECODE (IGC.CC_LINE
, NULL
, 201
, IGC.IGC_APPLICATION_ID)
, DECODE (IGC.CC_LINE
, NULL
, 'PO_DISTRIBUTIONS_ALL'
, IGC.CC_DIST_TYPE)
, DECODE (IGC.CC_LINE
, NULL
, DECODE (POD.PO_RELEASE_ID
, NULL
, 'PURCHASE_ORDER'
, 'RELEASE')
, IGC.CC_ENTITY_CODE)
, DECODE (IGC.CC_LINE
, NULL
, AID.PO_DISTRIBUTION_ID
, IGC.CC_DIST_ID)
, DECODE (IGC.CC_LINE
, NULL
, DECODE (POD.PO_RELEASE_ID
, NULL
, POD.PO_HEADER_ID
, POD.PO_RELEASE_ID)
, IGC.CC_DOC_ID)
, AID.PROJECT_ID
, AID.TASK_ID
, AID.EXPENDITURE_ORGANIZATION_ID
, AID.QUANTITY_VARIANCE
, NVL(AID.BASE_QUANTITY_VARIANCE
, AID.QUANTITY_VARIANCE)
, AID.AMOUNT_VARIANCE
, NVL(AID.BASE_AMOUNT_VARIANCE
, AID.AMOUNT_VARIANCE)
, -1
, -1
, -1
, 0
, AIL.UNIT_PRICE
, AIL.QUANTITY_INVOICED
, AID.UNIT_PRICE
, AID.QUANTITY_INVOICED
, AID.PARENT_INVOICE_ID
, AID.FINAL_MATCH_FLAG
, NVL(AID.EXTRA_PO_ERV
, 0)
, NVL(AID.BASE_AMOUNT
, AID.AMOUNT) - NVL(AID.BASE_AMOUNT_VARIANCE
, NVL(AID.AMOUNT_VARIANCE
, 0)) - NVL(AID.BASE_QUANTITY_VARIANCE
, NVL(AID.QUANTITY_VARIANCE
, 0))
, NVL(AID.AMOUNT
, 0) - NVL(AID.AMOUNT_VARIANCE
, 0) - NVL(AID.QUANTITY_VARIANCE
, 0)
, AID.RELATED_ID
, AID.CHARGE_APPLICABLE_TO_DIST_ID
, NVL(NVL(AID.CHARGE_APPLICABLE_TO_DIST_ID
, AID.RELATED_ID)
, AID.INVOICE_DISTRIBUTION_ID)
, AID.ENCUMBERED_FLAG
, POD.PO_DISTRIBUTION_ID
, POD.ENCUMBERED_FLAG
, POD.ENCUMBERED_AMOUNT
, POD.GL_ENCUMBERED_DATE
, POD.GL_ENCUMBERED_PERIOD_NAME
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, POD.DISTRIBUTION_NUM
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.CODE_COMBINATION_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.DESTINATION_TYPE_CODE
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, CASE WHEN (FSP.REQ_ENCUMBRANCE_FLAG ='Y' OR FSP.PURCH_ENCUMBRANCE_FLAG = 'Y') THEN PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG (DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, 200
, 201)
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, 'AP_INVOICES'
, DECODE (POD.PO_RELEASE_ID
, NULL
, 'PURCHASE_ORDER'
, 'RELEASE'))
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, AID.INVOICE_ID
, DECODE (POD.PO_RELEASE_ID
, NULL
, POD.PO_HEADER_ID
, POD.PO_RELEASE_ID))
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, 'AP_INV_DIST'
, 'PO_DISTRIBUTIONS_ALL')
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, AID.PARENT_REVERSAL_ID
, AID.PO_DISTRIBUTION_ID) ) ELSE 'N' END "UPG_AP_ENCUM_OPTION"
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, NULL
, 1001)
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, NULL
, POD.CODE_COMBINATION_ID) /*
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, NULL
, NVL(AID.BASE_AMOUNT
, AID.AMOUNT)-NVL(AID.BASE_AMOUNT_VARIANCE
, NVL(AID.AMOUNT_VARIANCE
, 0)) -NVL(AID.BASE_QUANTITY_VARIANCE
, NVL(AID.QUANTITY_VARIANCE
, 0)) )*/
, AP_UTILITIES_PKG.AP_ROUND_CURRENCY ( DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, (NVL(AID.BASE_AMOUNT
, AID.AMOUNT)-NVL(AID.BASE_AMOUNT_VARIANCE
, NVL(AID.AMOUNT_VARIANCE
, 0)) -NVL(AID.BASE_QUANTITY_VARIANCE
, NVL(AID.QUANTITY_VARIANCE
, 0)))
, ((NVL(AID.AMOUNT
, 0) - NVL(AID.AMOUNT_VARIANCE
, 0) - NVL(AID.QUANTITY_VARIANCE
, 0)) * NVL(POD.RATE
, 1)))
, ASP.BASE_CURRENCY_CODE) /*BUG7570932*/
, DECODE(NVL(AID.PO_DISTRIBUTION_ID
, -99)
, -99
, NULL
, NVL(AID.AMOUNT
, 0) - NVL(AID.AMOUNT_VARIANCE
, 0) - NVL(AID.QUANTITY_VARIANCE
, 0) )
, GLET.ENCUMBRANCE_TYPE_ID
, AID.DIST_CODE_COMBINATION_ID
, NVL(AID.BASE_AMOUNT
, AID.AMOUNT) -NVL(AID.BASE_AMOUNT_VARIANCE
, NVL(AID.AMOUNT_VARIANCE
, 0)) -NVL(AID.BASE_QUANTITY_VARIANCE
, NVL(AID.QUANTITY_VARIANCE
, 0))
, NVL(AID.AMOUNT
, 0) - NVL(AID.AMOUNT_VARIANCE
, 0) - NVL(AID.QUANTITY_VARIANCE
, 0)
, DECODE(AIL.LINE_TYPE_LOOKUP_CODE
, 'ERV'
, 'Y'
, 'N') OVERRIDE_ACCTD_AMT_FLAG
FROM AP_INVOICE_LINES_ALL AIL
, AP_INVOICE_DISTRIBUTIONS_ALL AID
, AP_AWT_GROUPS AWTG
, AP_INVOICE_DISTRIBUTIONS_ALL AWT_RELATED_IDS
, PO_DISTRIBUTIONS_ALL POD
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_ENCUMBRANCE_TYPES GLET
, IGC_CC_SLA_BFLOW_PRIOR_V IGC
, AP_SYSTEM_PARAMETERS_ALL ASP /*BUG7570932*/
WHERE AID.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
AND AID.INVOICE_ID = AIL.INVOICE_ID
AND AID.AWT_GROUP_ID = AWTG.GROUP_ID(+)
AND AID.AWT_RELATED_ID = AWT_RELATED_IDS.INVOICE_DISTRIBUTION_ID(+)
AND NVL(AID.POSTED_FLAG
, 'N') <> 'Y'
AND AID.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID(+)
AND AID.PO_DISTRIBUTION_ID = IGC.PO_DISTRIBUTION_ID(+)
AND AID.ORG_ID = FSP.ORG_ID
AND GLET.ENCUMBRANCE_TYPE_KEY='INVOICES'
AND AID.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID AND AID.ORG_ID = ASP.ORG_ID /*BUG7570932*/ UNION ALL SELECT ASAT.BC_EVENT_ID
, ASAT.INVOICE_DISTRIBUTION_ID
, AIL.DEFERRED_ACCTG_FLAG
, AIL.DEF_ACCTG_START_DATE
, AIL.DEF_ACCTG_END_DATE
, AIL.DEF_ACCTG_PERIOD_TYPE
, AIL.DEF_ACCTG_NUMBER_OF_PERIODS
, ASAT.INVOICE_DISTRIBUTION_ID /*
, DECODE(NVL(ASAT.CANCELLATION_FLAG
, 'N')
, 'Y'
, DECODE(ASAT.PARENT_REVERSAL_ID
, NULL
, 'N'
, 'Y')
, 'N') */
, 'N'
, ASAT.ACCOUNTING_DATE
, ASAT.AMOUNT
, ASAT.ASSETS_TRACKING_FLAG
, ASAT.ATTRIBUTE_CATEGORY
, ASAT.ATTRIBUTE1
, ASAT.ATTRIBUTE10
, ASAT.ATTRIBUTE11
, ASAT.ATTRIBUTE12
, ASAT.ATTRIBUTE13
, ASAT.ATTRIBUTE14
, ASAT.ATTRIBUTE15
, ASAT.ATTRIBUTE2
, ASAT.ATTRIBUTE3
, ASAT.ATTRIBUTE4
, ASAT.ATTRIBUTE5
, ASAT.ATTRIBUTE6
, ASAT.ATTRIBUTE7
, ASAT.ATTRIBUTE8
, ASAT.ATTRIBUTE9
, ASAT.AWARD_ID
, ASAT.DESCRIPTION
, ASAT.DIST_CODE_COMBINATION_ID
, ASAT.DISTRIBUTION_LINE_NUMBER
, ASAT.EXPENDITURE_ITEM_DATE
, ASAT.EXPENDITURE_TYPE
, ASAT.INCOME_TAX_REGION
, ASAT.MERCHANT_DOCUMENT_NUMBER
, ASAT.MERCHANT_REFERENCE
, ASAT.MERCHANT_TAX_REG_NUMBER
, ASAT.MERCHANT_TAXPAYER_ID
, ASAT.PERIOD_NAME
, ASAT.REFERENCE_1
, ASAT.REFERENCE_2
, ASAT.STAT_AMOUNT
, ASAT.TAX_RECOVERABLE_FLAG
, ASAT.TYPE_1099
, AWTG.NAME
, AIL.LINE_TYPE_LOOKUP_CODE
, AIL.DESCRIPTION
, AIL.LINE_SOURCE
, AIL.LINE_GROUP_NUMBER
, AIL.ITEM_DESCRIPTION
, AIL.ACCOUNT_SEGMENT
, AIL.BALANCING_SEGMENT
, AIL.COST_CENTER_SEGMENT
, AIL.OVERLAY_DIST_CODE_CONCAT
, AIL.DEFAULT_DIST_CCID
, AIL.ASSET_BOOK_TYPE_CODE
, AIL.EXPENSE_GROUP
, AIL.MERCHANT_NAME
, AIL.ATTRIBUTE_CATEGORY
, AIL.ATTRIBUTE1
, AIL.ATTRIBUTE2
, AIL.ATTRIBUTE3
, AIL.ATTRIBUTE4
, AIL.ATTRIBUTE5
, AIL.ATTRIBUTE6
, AIL.ATTRIBUTE7
, AIL.ATTRIBUTE8
, AIL.ATTRIBUTE9
, AIL.ATTRIBUTE10
, AIL.ATTRIBUTE11
, AIL.ATTRIBUTE12
, AIL.ATTRIBUTE13
, AIL.ATTRIBUTE14
, AIL.ATTRIBUTE15
, AIL.GLOBAL_ATTRIBUTE_CATEGORY
, AIL.GLOBAL_ATTRIBUTE1
, AIL.GLOBAL_ATTRIBUTE2
, AIL.GLOBAL_ATTRIBUTE3
, AIL.GLOBAL_ATTRIBUTE4
, AIL.GLOBAL_ATTRIBUTE5
, AIL.GLOBAL_ATTRIBUTE6
, AIL.GLOBAL_ATTRIBUTE7
, AIL.GLOBAL_ATTRIBUTE8
, AIL.GLOBAL_ATTRIBUTE9
, AIL.GLOBAL_ATTRIBUTE10
, AIL.GLOBAL_ATTRIBUTE11
, AIL.GLOBAL_ATTRIBUTE12
, AIL.GLOBAL_ATTRIBUTE13
, AIL.GLOBAL_ATTRIBUTE14
, AIL.GLOBAL_ATTRIBUTE15
, AIL.GLOBAL_ATTRIBUTE16
, AIL.GLOBAL_ATTRIBUTE17
, AIL.GLOBAL_ATTRIBUTE18
, AIL.GLOBAL_ATTRIBUTE19
, AIL.GLOBAL_ATTRIBUTE20
, AIL.SUMMARY_TAX_LINE_ID
, ASAT.ASSETS_ADDITION_FLAG
, ASAT.LINE_TYPE_LOOKUP_CODE
, -1
, ASAT.REVERSAL_FLAG
, ASAT.GLOBAL_ATTRIBUTE_CATEGORY
, ASAT.GLOBAL_ATTRIBUTE1
, ASAT.GLOBAL_ATTRIBUTE2
, ASAT.GLOBAL_ATTRIBUTE3
, ASAT.GLOBAL_ATTRIBUTE4
, ASAT.GLOBAL_ATTRIBUTE5
, ASAT.GLOBAL_ATTRIBUTE6
, ASAT.GLOBAL_ATTRIBUTE7
, ASAT.GLOBAL_ATTRIBUTE8
, ASAT.GLOBAL_ATTRIBUTE9
, ASAT.GLOBAL_ATTRIBUTE10
, ASAT.GLOBAL_ATTRIBUTE11
, ASAT.GLOBAL_ATTRIBUTE12
, ASAT.GLOBAL_ATTRIBUTE13
, ASAT.GLOBAL_ATTRIBUTE14
, ASAT.GLOBAL_ATTRIBUTE15
, ASAT.GLOBAL_ATTRIBUTE16
, ASAT.GLOBAL_ATTRIBUTE17
, ASAT.GLOBAL_ATTRIBUTE18
, ASAT.GLOBAL_ATTRIBUTE19
, ASAT.GLOBAL_ATTRIBUTE20
, ASAT.CANCELLATION_FLAG
, ASAT.INVOICE_LINE_NUMBER
, ASAT.INVOICE_DISTRIBUTION_ID
, ASAT.PARENT_REVERSAL_ID
, ASAT.AWT_FLAG
, ASAT.SELF_ASSESSED_TAX_LIAB_CCID
, ASAT.DETAIL_TAX_DIST_ID
, ASAT.SELF_ASSESSED_FLAG
, ASAT.DIST_CODE_COMBINATION_ID
, -1
, NVL(AIL.BASE_AMOUNT
, AIL.AMOUNT)
, AIL.AMOUNT
, NVL(ASAT.ROUNDING_AMT
, 0)
, NVL(ASAT.BASE_AMOUNT
, ASAT.AMOUNT)
, (NVL(ASAT.BASE_AMOUNT
, ASAT.AMOUNT) - NVL(ASAT.ROUNDING_AMT
, 0))
, 'AP_INV_DIST'
, ASAT.PO_DISTRIBUTION_ID
, 200
, 'AP_INV_DIST'
, 'AP_INVOICES'
, ASAT.INVOICE_DISTRIBUTION_ID
, ASAT.INVOICE_ID
, DECODE (IGC.CC_LINE
, NULL
, 201
, IGC.IGC_APPLICATION_ID)
, DECODE (IGC.CC_LINE
, NULL
, 'PO_DISTRIBUTIONS_ALL'
, IGC.CC_DIST_TYPE)
, DECODE (IGC.CC_LINE
, NULL
, DECODE (POD.PO_RELEASE_ID
, NULL
, 'PURCHASE_ORDER'
, 'RELEASE')
, IGC.CC_ENTITY_CODE)
, DECODE (IGC.CC_LINE
, NULL
, ASAT.PO_DISTRIBUTION_ID
, IGC.CC_DIST_ID)
, DECODE (IGC.CC_LINE
, NULL
, DECODE (POD.PO_RELEASE_ID
, NULL
, POD.PO_HEADER_ID
, POD.PO_RELEASE_ID)
, IGC.CC_DOC_ID)
, ASAT.PROJECT_ID
, ASAT.TASK_ID
, ASAT.EXPENDITURE_ORGANIZATION_ID
, ASAT.QUANTITY_VARIANCE
, NVL(ASAT.BASE_QUANTITY_VARIANCE
, ASAT.QUANTITY_VARIANCE)
, ASAT.AMOUNT_VARIANCE
, NVL(ASAT.BASE_AMOUNT_VARIANCE
, ASAT.AMOUNT_VARIANCE)
, -1
, -1
, -1
, 0
, AIL.UNIT_PRICE
, AIL.QUANTITY_INVOICED
, ASAT.UNIT_PRICE
, ASAT.QUANTITY_INVOICED
, ASAT.PARENT_INVOICE_ID
, ASAT.FINAL_MATCH_FLAG
, NVL(ASAT.EXTRA_PO_ERV
, 0)
, NVL(ASAT.BASE_AMOUNT
, ASAT.AMOUNT) - NVL(ASAT.BASE_AMOUNT_VARIANCE
, NVL(ASAT.AMOUNT_VARIANCE
, 0)) - NVL(ASAT.BASE_QUANTITY_VARIANCE
, NVL(ASAT.QUANTITY_VARIANCE
, 0))
, NVL(ASAT.AMOUNT
, 0) - NVL(ASAT.AMOUNT_VARIANCE
, 0) - NVL(ASAT.QUANTITY_VARIANCE
, 0)
, ASAT.RELATED_ID
, ASAT.CHARGE_APPLICABLE_TO_DIST_ID
, NVL(NVL(ASAT.CHARGE_APPLICABLE_TO_DIST_ID
, ASAT.RELATED_ID)
, ASAT.INVOICE_DISTRIBUTION_ID)
, ASAT.ENCUMBERED_FLAG
, POD.PO_DISTRIBUTION_ID
, POD.ENCUMBERED_FLAG
, POD.ENCUMBERED_AMOUNT
, POD.GL_ENCUMBERED_DATE
, POD.GL_ENCUMBERED_PERIOD_NAME
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, POD.DISTRIBUTION_NUM
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.CODE_COMBINATION_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.DESTINATION_TYPE_CODE
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, 'N'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE(AIL.LINE_TYPE_LOOKUP_CODE
, 'ERV'
, 'Y'
, 'N') OVERRIDE_ACCTD_AMT_FLAG
FROM AP_INVOICE_LINES_ALL AIL
, AP_SELF_ASSESSED_TAX_DIST_ALL ASAT
, AP_AWT_GROUPS AWTG
, PO_DISTRIBUTIONS_ALL POD
, IGC_CC_SLA_BFLOW_PRIOR_V IGC
WHERE ASAT.INVOICE_LINE_NUMBER = AIL.LINE_NUMBER
AND ASAT.INVOICE_ID = AIL.INVOICE_ID
AND ASAT.AWT_GROUP_ID = AWTG.GROUP_ID(+)
AND NVL(ASAT.POSTED_FLAG
, 'N') <> 'Y'
AND ASAT.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID(+) AND ASAT.PO_DISTRIBUTION_ID = IGC.PO_DISTRIBUTION_ID(+)