APPS.GMS_COST_PLUS_EXTN dependencies on PO_REQ_DISTRIBUTIONS

Line 258: po_req_distributions RD,

254: adl.bud_task_id,
255: adl.ind_compiled_set_id
256: from po_requisition_headers RH,
257: po_requisition_lines RL,
258: po_req_distributions RD,
259: gms_award_distributions ADL
260: where rh.type_lookup_code = 'PURCHASE'
261: and rh.requisition_header_id = rl.requisition_header_id
262: and nvl(rl.modified_by_agent_flag,'N') = 'N'

Line 1198: --po_req_distributions_all por

1194: select adl.ind_compiled_set_id
1195: into l_compiled_set_id
1196: from gms_award_distributions adl
1197: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1198: --po_req_distributions_all por
1199: where adl.award_id = x_award_id
1200: and adl.task_id = x_task_id
1201: and adl.distribution_id = x_document_distribution_id
1202: and adl.document_type = 'REQ'

Line 2094: po_req_distributions_all req

2090: SELECT adl.burdenable_raw_cost burden_amount,
2091: adl.adl_line_num,
2092: adl.award_set_id
2093: FROM gms_award_distributions adl ,
2094: po_req_distributions_all req
2095: WHERE adl.distribution_id = p_record.document_distribution_id
2096: AND req.distribution_id = p_record.document_distribution_id
2097: AND req.award_id = adl.award_set_id
2098: and adl.adl_status = 'A'

Line 4373: po_req_distributions_all req

4369: --
4370: select adl.ind_compiled_set_id
4371: into x_ind_compiled_set_id
4372: from gms_award_distributions adl,
4373: po_req_distributions_all req
4374: where req.distribution_id = x_distribution_id
4375: and req.award_id = adl.award_set_id
4376: and adl.adl_line_num = 1 ;
4377:

Line 4442: po_req_distributions_all req

4438: --
4439: select adl.burdenable_raw_cost
4440: into x_burdenable_raw_cost
4441: from gms_award_distributions adl,
4442: po_req_distributions_all req
4443: where req.distribution_id = x_distribution_id
4444: and req.award_id = adl.award_set_id
4445: and adl.adl_line_num = 1 ;
4446: