Product: | IGI - Public Sector Financials International |
---|---|
Description: | Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL. |
Implementation/DBA Data: | APPS.IGI_INVOICE_DISTRIBUTIONS_V |
SELECT AP.PREPAY_DISTRIBUTION_ID
, AP.ACCOUNTING_EVENT_ID
, AP.ACCOUNTING_DATE
, AP.ACCRUAL_POSTED_FLAG
, AP.ASSETS_ADDITION_FLAG
, AP.ASSETS_TRACKING_FLAG
, AP.CASH_POSTED_FLAG
, AP.DISTRIBUTION_LINE_NUMBER
, AP.DIST_CODE_COMBINATION_ID
, AP.INVOICE_ID
, IGI.LAST_UPDATED_BY
, IGI.LAST_UPDATE_DATE
, AP.LINE_TYPE_LOOKUP_CODE
, AP.PERIOD_NAME
, AP.SET_OF_BOOKS_ID
, AP.ACCTS_PAY_CODE_COMBINATION_ID
, AP.AMOUNT
, AP.BASE_AMOUNT
, AP.BASE_INVOICE_PRICE_VARIANCE
, AP.BATCH_ID
, AP.CREATED_BY
, AP.CREATION_DATE
, AP.DESCRIPTION
, AP.EXCHANGE_RATE_VARIANCE
, AP.FINAL_MATCH_FLAG
, AP.INCOME_TAX_REGION
, AP.INVOICE_PRICE_VARIANCE
, AP.LAST_UPDATE_LOGIN
, AP.MATCH_STATUS_FLAG
, AP.POSTED_FLAG
, AP.PO_DISTRIBUTION_ID
, AP.PROGRAM_APPLICATION_ID
, AP.PROGRAM_ID
, AP.PROGRAM_UPDATE_DATE
, AP.QUANTITY_INVOICED
, AP.RATE_VAR_CODE_COMBINATION_ID
, AP.REQUEST_ID
, AP.REVERSAL_FLAG
, AP.TYPE_1099
, AP.UNIT_PRICE
, AP.VAT_CODE
, AP.AMOUNT_ENCUMBERED
, AP.BASE_AMOUNT_ENCUMBERED
, AP.ENCUMBERED_FLAG
, AP.EXCHANGE_DATE
, AP.EXCHANGE_RATE
, AP.EXCHANGE_RATE_TYPE
, AP.PRICE_ADJUSTMENT_FLAG
, AP.PRICE_VAR_CODE_COMBINATION_ID
, AP.QUANTITY_UNENCUMBERED
, AP.STAT_AMOUNT
, AP.AMOUNT_TO_POST
, AP.ATTRIBUTE1
, AP.ATTRIBUTE10
, AP.ATTRIBUTE11
, AP.ATTRIBUTE12
, AP.ATTRIBUTE13
, AP.ATTRIBUTE14
, AP.ATTRIBUTE15
, AP.ATTRIBUTE2
, AP.ATTRIBUTE3
, AP.ATTRIBUTE4
, AP.ATTRIBUTE5
, AP.ATTRIBUTE6
, AP.ATTRIBUTE7
, AP.ATTRIBUTE8
, AP.ATTRIBUTE9
, AP.ATTRIBUTE_CATEGORY
, AP.BASE_AMOUNT_TO_POST
, AP.CASH_JE_BATCH_ID
, AP.EXPENDITURE_ITEM_DATE
, AP.EXPENDITURE_ORGANIZATION_ID
, AP.EXPENDITURE_TYPE
, AP.JE_BATCH_ID
, AP.PARENT_INVOICE_ID
, AP.PA_ADDITION_FLAG
, AP.PA_QUANTITY
, AP.POSTED_AMOUNT
, AP.POSTED_BASE_AMOUNT
, AP.PREPAY_AMOUNT_REMAINING
, AP.PROJECT_ACCOUNTING_CONTEXT
, AP.PROJECT_ID
, AP.TASK_ID
, AP.USSGL_TRANSACTION_CODE
, AP.USSGL_TRX_CODE_CONTEXT
, AP.EARLIEST_SETTLEMENT_DATE
, AP.REQ_DISTRIBUTION_ID
, AP.QUANTITY_VARIANCE
, AP.BASE_QUANTITY_VARIANCE
, AP.PACKET_ID
, AP.AWT_FLAG
, AP.AWT_GROUP_ID
, AP.AWT_TAX_RATE_ID
, AP.AWT_GROSS_AMOUNT
, AP.AWT_INVOICE_ID
, AP.AWT_ORIGIN_GROUP_ID
, AP.REFERENCE_1
, AP.REFERENCE_2
, AP.ORG_ID
, AP.OTHER_INVOICE_ID
, AP.AWT_INVOICE_PAYMENT_ID
, AP.GLOBAL_ATTRIBUTE_CATEGORY
, AP.GLOBAL_ATTRIBUTE1
, AP.GLOBAL_ATTRIBUTE2
, AP.GLOBAL_ATTRIBUTE3
, AP.GLOBAL_ATTRIBUTE4
, AP.GLOBAL_ATTRIBUTE5
, AP.GLOBAL_ATTRIBUTE6
, AP.GLOBAL_ATTRIBUTE7
, AP.GLOBAL_ATTRIBUTE8
, AP.GLOBAL_ATTRIBUTE9
, AP.GLOBAL_ATTRIBUTE10
, AP.GLOBAL_ATTRIBUTE11
, AP.GLOBAL_ATTRIBUTE12
, AP.GLOBAL_ATTRIBUTE13
, AP.GLOBAL_ATTRIBUTE14
, AP.GLOBAL_ATTRIBUTE15
, AP.GLOBAL_ATTRIBUTE16
, AP.GLOBAL_ATTRIBUTE17
, AP.GLOBAL_ATTRIBUTE18
, AP.GLOBAL_ATTRIBUTE19
, AP.GLOBAL_ATTRIBUTE20
, AP.AMOUNT_INCLUDES_TAX_FLAG
, AP.TAX_CALCULATED_FLAG
, AP.LINE_GROUP_NUMBER
, AP.RECEIPT_VERIFIED_FLAG
, AP.RECEIPT_REQUIRED_FLAG
, AP.RECEIPT_MISSING_FLAG
, AP.JUSTIFICATION
, AP.EXPENSE_GROUP
, AP.START_EXPENSE_DATE
, AP.END_EXPENSE_DATE
, AP.RECEIPT_CURRENCY_CODE
, AP.RECEIPT_CONVERSION_RATE
, AP.RECEIPT_CURRENCY_AMOUNT
, AP.DAILY_AMOUNT
, AP.WEB_PARAMETER_ID
, AP.ADJUSTMENT_REASON
, AP.AWARD_ID
, AP.MRC_DIST_CODE_COMBINATION_ID
, AP.MRC_BASE_AMOUNT
, AP.MRC_BASE_INV_PRICE_VARIANCE
, AP.MRC_EXCHANGE_RATE_VARIANCE
, AP.MRC_RATE_VAR_CCID
, AP.MRC_EXCHANGE_DATE
, AP.MRC_EXCHANGE_RATE
, AP.MRC_EXCHANGE_RATE_TYPE
, AP.MRC_RECEIPT_CONVERSION_RATE
, AP.DIST_MATCH_TYPE
, AP.RCV_TRANSACTION_ID
, AP.INVOICE_DISTRIBUTION_ID
, AP.PARENT_REVERSAL_ID
, AP.TAX_RECOVERY_RATE
, AP.TAX_RECOVERY_OVERRIDE_FLAG
, AP.TAX_RECOVERABLE_FLAG
, AP.TAX_CODE_OVERRIDE_FLAG
, AP.TAX_CODE_ID
, AP.PA_CC_AR_INVOICE_ID
, AP.PA_CC_AR_INVOICE_LINE_NUM
, AP.PA_CC_PROCESSED_CODE
, AP.MERCHANT_DOCUMENT_NUMBER
, AP.MERCHANT_NAME
, AP.MERCHANT_REFERENCE
, AP.MERCHANT_TAX_REG_NUMBER
, AP.MERCHANT_TAXPAYER_ID
, AP.COUNTRY_OF_SUPPLY
, AP.MATCHED_UOM_LOOKUP_CODE
, AP.GMS_BURDENABLE_RAW_COST
, AP.CREDIT_CARD_TRX_ID
, AP.UPGRADE_POSTED_AMT
, AP.UPGRADE_BASE_POSTED_AMT
, AP.INVENTORY_TRANSFER_STATUS
, IGI.IGI_MPP_ID
, IGI.IGI_MPP_LINE_NUM
, IGI.IGI_MPP_STATUS
, IGI.IGI_MPP_ACCT_RULE
, IGI.IGI_MPP_FIRST_GL_DATE
, IGI.IGI_MPP_DURATION
, IGI.IGI_MPP_EXP_CCID
, IGI.IGI_SAP_FLAG
, IGI.ROWID IGI_ROWID
, AP.ROWID DIST_ROWID
FROM AP_INVOICE_DISTRIBUTIONS_ALL AP
, IGI_INVOICE_DISTRIBUTIONS_ALL IGI
WHERE NVL(AP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND IGI.INVOICE_ID = AP.INVOICE_ID
AND IGI.DISTRIBUTION_LINE_NUMBER = AP.DISTRIBUTION_LINE_NUMBER