1. Tables and Views for Financials
  2. AP_CHARGE_PO_DETAILS_V

AP_CHARGE_PO_DETAILS_V

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: VIEW

Columns

Name

CHARGE_PO_DIST_CCID

CHARGE_DIST_ID

Query

SQL_Statement

SELECT POD.CODE_COMBINATION_ID CHARGE_PO_DIST_CCID,

INVOICE_DISTRIBUTION_ID CHARGE_DIST_ID

FROM ap_invoice_distributions_all AID,

PO_DISTRIBUTIONS_ALL POD

WHERE 1 =1

AND AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM','ACCRUAL')

AND AID.PO_DISTRIBUTION_ID IS NOT NULL

AND POD.PO_DISTRIBUTION_ID =AID.PO_DISTRIBUTION_ID

UNION

SELECT POD.CODE_COMBINATION_ID CHARGE_PO_DIST_CCID,

INVOICE_DISTRIBUTION_ID CHARGE_DIST_ID

FROM ap_self_assessed_tax_dist_all AID,

PO_DISTRIBUTIONS_ALL POD

WHERE 1 =1

AND AID.LINE_TYPE_LOOKUP_CODE IN ('ITEM','ACCRUAL')

AND AID.PO_DISTRIBUTION_ID IS NOT NULL

AND POD.PO_DISTRIBUTION_ID =AID.PO_DISTRIBUTION_ID