DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on PO_REQUISITION_HEADERS

Line 235: po_requisition_headers_all rh,

231: rl.vendor_id
232: from po_req_distributions_all rd,
233: gms_award_distributions adl,
234: po_requisition_lines_all rl,
235: po_requisition_headers_all rh,
236: gl_period_statuses gps,
237: pa_expenditure_types pet
238: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
239: AND RH.TYPE_LOOKUP_CODE = 'PURCHASE'

Line 1438: po_requisition_headers req,

1434: g_error_stage := 'VI-REQ';
1435: SELECT DISTINCT line.vendor_id
1436: INTO x_vendor_id
1437: FROM po_requisition_lines line,
1438: po_requisition_headers req,
1439: gms_bc_packets bc
1440: WHERE bc.packet_id = x_packet_id
1441: AND line.requisition_header_id = req.requisition_header_id
1442: AND bc.document_header_id = req.requisition_header_id