DBA Data[Home] [Help]

APPS.ITG_X_UTILS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 109: po_req_distributions_all reqDist

105: CURSOR getSegment1 IS
106: SELECT reqHead.segment1
107: FROM po_requisition_headers_all reqHead,
108: po_requisition_lines_all reqLine,
109: po_req_distributions_all reqDist
110: WHERE reqHead.requisition_header_id = reqLine.requisition_header_id
111: AND reqLine.requisition_line_id = reqDist.requisition_line_id
112: AND reqDist.distribution_id = poReqDistId;
113: BEGIN

Line 131: po_req_distributions_all reqDist

127: returnValue po_requisition_headers_all.segment1%TYPE;
128: CURSOR getLineNum IS
129: SELECT reqLine.line_num
130: FROM po_requisition_lines_all reqLine,
131: po_req_distributions_all reqDist
132: WHERE reqLine.requisition_line_id = reqDist.requisition_line_id
133: AND reqDist.distribution_id = poReqDistId;
134: BEGIN
135: IF poReqDistId IS NOT NULL THEN