DBA Data[Home] [Help]

APPS.AP_OTHR_CHRG_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1444: UPDATE ap_invoice_distributions_all id

1440: AND gcc.code_combination_id = ail.default_dist_ccid
1441: AND rcv.transaction_id = ail.rcv_transaction_id;
1442:
1443:
1444: UPDATE ap_invoice_distributions_all id
1445: SET (project_id,
1446: task_id,
1447: expenditure_type,
1448: expenditure_item_date,

Line 1472: FROM ap_invoice_distributions_all aid,

1468: 'SHOP FLOOR', PD.expenditure_organization_id,
1469: 'INVENTORY', PD.expenditure_organization_id), --expenditure_organization_id
1470: DECODE(PD.destination_type_code,
1471: 'EXPENSE', PD.award_id) --award_id
1472: FROM ap_invoice_distributions_all aid,
1473: rcv_transactions rcv,
1474: po_distributions_all pd
1475: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
1476: AND aid.rcv_transaction_id = rcv.transaction_id