DBA Data[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1002: FROM po_distributions_ap_v PD,

998: NULL), --expenditure_organization_id
999: DECODE(PD.destination_type_code,
1000: 'EXPENSE', PD.award_id), --award_id
1001: ap_invoice_distributions_s.nextval
1002: FROM po_distributions_ap_v PD,
1003: rcv_transactions RT
1004: WHERE PD.line_location_id = x_po_line_location_id
1005: and Pd.line_location_id = RT.po_line_location_id
1006: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id;

Line 1271: FROM po_distributions_ap_v pd

1267: x_dist_tab(i).expenditure_type,
1268: x_dist_tab(i).expenditure_item_date,
1269: x_dist_tab(i).expenditure_organization_id,
1270: x_dist_tab(i).invoice_distribution_id
1271: FROM po_distributions_ap_v pd
1272: WHERE pd.po_distribution_id = x_dist_tab(i).po_distribution_id;
1273:
1274: -- Bug 5554493
1275: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1508: --po_distributions_ap_v.code_combination_id is accrual account

1504: --bugfix:4668058 added the following clause
1505: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1506: ) THEN
1507:
1508: --po_distributions_ap_v.code_combination_id is accrual account
1509: --if accruing on receipt or else charge account
1510:
1511: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1512:

Line 2149: FROM PO_DISTRIBUTIONS_AP_V PD,

2145: G_PRODUCT_CATEGORY, --product_category
2146: G_USER_DEFINED_FISC_CLASS, --user_defined_fisc_clas
2147: G_ASSESSABLE_VALUE,
2148: G_dflt_tax_class_code
2149: FROM PO_DISTRIBUTIONS_AP_V PD,
2150: MTL_SYSTEM_ITEMS MSI,
2151: PO_AP_RECEIPT_MATCH_V RCV,
2152: RCV_SHIPMENT_LINES RSL,
2153: RCV_TRANSACTIONS RT --for 7015553