DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1389: po_req_distributions_all pd

1385: SET adl_status = 'I'
1386: WHERE adl.adl_status = 'A'
1387: AND (adl.award_set_id,adl.document_type) IN ( SELECT adl2.award_set_id,adl2.document_type
1388: FROM gms_award_distributions adl2,
1389: po_req_distributions_all pd
1390: WHERE g_document_type_tab(i) = 'REQ'
1391: AND adl2.document_type = 'REQ'
1392: AND adl2.adl_line_num = 1
1393: AND adl2.distribution_id = pd.distribution_id

Line 2427: po_req_distributions_all pord,

2423: pov.vendor_id,
2424: adl.ind_compiled_set_id
2425: FROM gms_award_distributions adl,
2426: po_requisition_lines_all porl,
2427: po_req_distributions_all pord,
2428: po_vendors pov
2429: WHERE pord.distribution_id = p_req_dist_id
2430: AND pord.project_id IS NOT NULL
2431: AND NVL (pord.award_id, l_dist_award_id) = adl.award_set_id