APPS.ITG_X_UTILS dependencies on PO_REQUISITION_LINES_ALL

Line 108: po_requisition_lines_all reqLine,

104: returnValue po_requisition_headers_all.segment1%TYPE;
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;

Line 123: ** Given a po_req_distribution_id, return the line_num from po_requisition_lines_all

119: RETURN returnValue;
120: END getRequistnid;
121:
122: /*
123: ** Given a po_req_distribution_id, return the line_num from po_requisition_lines_all
124: */
125: function getReqLineNum ( poReqDistId IN Number )
126: RETURN varchar2 AS
127: returnValue po_requisition_headers_all.segment1%TYPE;

Line 130: FROM po_requisition_lines_all reqLine,

126: RETURN varchar2 AS
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

Line 388: FROM po_requisition_lines_all

384: ) RETURN NUMBER AS
385: returnValue NUMBER := 0;
386: CURSOR sumValue IS
387: SELECT sum( quantity * unit_price )
388: FROM po_requisition_lines_all
389: WHERE requisition_header_id = reqHeaderId;
390: BEGIN
391: IF reqHeaderId IS NOT NULL THEN
392: OPEN sumValue;