Product: | IGI - Public Sector Financials International |
---|---|
Description: | Contains information for both Core and OPSFI Invoice Distributions forms |
Implementation/DBA Data: | APPS.IGI_MPP_AP_DIST_MERGE_V |
SELECT IMD.ROWID
, IMD.DISTRIBUTION_LINE_NUMBER
, AID.LINE_TYPE
, AID.AMOUNT
, AID.VAT_CODE
, AID.TAX_CODE_ID
, DECODE(AID.TAX_CODE_ID
, NULL
, NULL
, ATC.NAME) TAX_CODE_NAME
, AID.ACCOUNTING_DATE
, AID.DIST_CODE_COMBINATION_ID
, IMS.FUTURE_POSTING_CCID
, IMD.INVOICE_ID
, IMD.START_DATE
, IMD.DURATION
, IMD.IGNORE_MPP_FLAG
, IMD.ACCOUNTING_RULE_ID
, RA.NAME ACCOUNTING_RULE_NAME
, DECODE( RA.TYPE
, 'ACC_DUR'
, 'Y'
, 'N') VARIABLE_RULE_FLAG
, IMD.CREATED_BY
, IMD.CREATION_DATE
, IMD.LAST_UPDATED_BY
, IMD.LAST_UPDATE_DATE
, IMD.LAST_UPDATE_LOGIN
FROM RA_RULES RA
, AP_INVOICE_DISTRIBUTIONS_V AID
, AP_TAX_CODES ATC
, IGI_MPP_SETUP IMS
, IGI_MPP_AP_INVOICE_DISTS IMD
WHERE AID.INVOICE_ID = IMD.INVOICE_ID
AND AID.DISTRIBUTION_LINE_NUMBER = IMD.DISTRIBUTION_LINE_NUMBER
AND AID.SET_OF_BOOKS_ID = IMS.SET_OF_BOOKS_ID
AND AID.TAX_CODE_ID = ATC.TAX_ID(+)
AND IMD.ACCOUNTING_RULE_ID = RA.RULE_ID