DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1418: po_req_distributions_all pd

1414: SET adl_status = 'I'
1415: WHERE adl.adl_status = 'A'
1416: AND (adl.award_set_id,adl.document_type) IN ( SELECT adl2.award_set_id,adl2.document_type
1417: FROM gms_award_distributions adl2,
1418: po_req_distributions_all pd
1419: WHERE g_document_type_tab(i) = 'REQ'
1420: AND adl2.document_type = 'REQ'
1421: AND adl2.adl_line_num = 1
1422: AND adl2.distribution_id = pd.distribution_id

Line 2653: po_req_distributions_all pord,

2649: pov.vendor_id,
2650: adl.ind_compiled_set_id
2651: FROM gms_award_distributions adl,
2652: po_requisition_lines_all porl,
2653: po_req_distributions_all pord,
2654: po_vendors pov
2655: WHERE pord.distribution_id = p_req_dist_id
2656: AND pord.project_id IS NOT NULL
2657: AND NVL (pord.award_id, l_dist_award_id) = adl.award_set_id