DBA Data[Home] [Help]

APPS.AP_OTHR_CHRG_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1355: UPDATE ap_invoice_distributions_all id

1351: AND gcc.code_combination_id = ail.default_dist_ccid
1352: AND rcv.transaction_id = ail.rcv_transaction_id;
1353:
1354:
1355: UPDATE ap_invoice_distributions_all id
1356: SET (project_id,
1357: task_id,
1358: expenditure_type,
1359: expenditure_item_date,

Line 1383: FROM ap_invoice_distributions_all aid,

1379: 'SHOP FLOOR', PD.expenditure_organization_id,
1380: 'INVENTORY', PD.expenditure_organization_id), --expenditure_organization_id
1381: DECODE(PD.destination_type_code,
1382: 'EXPENSE', PD.award_id) --award_id
1383: FROM ap_invoice_distributions_all aid,
1384: rcv_transactions rcv,
1385: po_distributions_all pd
1386: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
1387: AND aid.rcv_transaction_id = rcv.transaction_id