DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 6384: po_distributions_all pd

6380: SELECT pd.line_location_id,
6381: SUM(d.amount)
6382: FROM ap_ppa_invoice_dists_gt d,
6383: ap_ppa_invoice_lines_gt l,
6384: po_distributions_all pd
6385: WHERE l.instruction_id = d.instruction_id
6386: AND l.adj_type = 'PPA'
6387: AND d.instruction_id = p_instruction_rec.invoice_id
6388: AND d.po_distribution_id = pd.po_distribution_id

Line 6401: po_distributions_all pd

6397: FND_GLOBAL.conc_login_id,
6398: FND_GLOBAL.conc_request_id
6399: FROM ap_ppa_invoice_dists_gt d,
6400: ap_ppa_invoice_lines_gt l,
6401: po_distributions_all pd
6402: WHERE l.instruction_id = d.instruction_id
6403: AND l.adj_type = 'PPA'
6404: AND d.instruction_id = p_instruction_rec.invoice_id
6405: AND d.po_distribution_id = pd.po_distribution_id

Line 6978: UPDATE po_distributions_all pd

6974: CLOSE po_shipments;
6975:
6976: ELSE
6977:
6978: UPDATE po_distributions_all pd
6979: SET last_update_date = SYSDATE,
6980: last_updated_by = FND_GLOBAL.user_id,
6981: last_update_login = FND_GLOBAL.conc_login_id,
6982: request_id = FND_GLOBAL.conc_request_id,