VIEW: APPS.IGI_INVOICE_DISTRIBUTIONS_V

Source

View Text - Preformatted

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 ,ap.invoice_line_number FROM AP_INVOICE_DISTRIBUTIONS_ALL AP, IGI_INVOICE_DISTRIBUTIONS IGI WHERE igi.invoice_id = ap.invoice_id AND igi.distribution_line_number = ap.distribution_line_number AND igi.invoice_line_number = ap.invoice_line_number

View Text - HTML Formatted

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
, AP.INVOICE_LINE_NUMBER
FROM AP_INVOICE_DISTRIBUTIONS_ALL AP
, IGI_INVOICE_DISTRIBUTIONS IGI
WHERE IGI.INVOICE_ID = AP.INVOICE_ID
AND IGI.DISTRIBUTION_LINE_NUMBER = AP.DISTRIBUTION_LINE_NUMBER
AND IGI.INVOICE_LINE_NUMBER = AP.INVOICE_LINE_NUMBER