APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES_ALL

Line 549: FROM po_lines_all

545: v_progress := '110';
546:
547: SELECT line_num
548: INTO v_line_num
549: FROM po_lines_all
550: WHERE po_line_id = p_line_id;
551:
552: RETURN v_line_num;
553:

Line 2208: FROM po_headers_all poh,po_lines_all pol

2204: if (c_entity_type = 'PO LINE' OR c_entity_type = 'BLANKET LINE') then
2205:
2206: SELECT poh.segment1,poh.po_header_id,pol.line_num
2207: INTO c_po_num,c_po_header_id,c_line_num
2208: FROM po_headers_all poh,po_lines_all pol
2209: WHERE
2210: poh.po_header_id = pol.po_header_id and
2211: pol.po_line_id = c_entity_id;
2212:

Line 2312: FROM po_headers_all poh,po_line_locations_all pll,po_lines_all pol

2308: ELSE
2309:
2310: SELECT segment1,poh.po_header_id,pll.shipment_num,pol.line_num
2311: INTO c_po_num,c_po_header_id,c_location_num,c_line_num
2312: FROM po_headers_all poh,po_line_locations_all pll,po_lines_all pol
2313: WHERE
2314: poh.po_header_id = pll.po_header_id and
2315: pll.line_location_id = c_entity_id and
2316: pol.po_line_id = pll.po_line_id;

Line 3918: from po_lines_all

3914: --get the line number using line id
3915:
3916: select line_num ,item_id, job_id, org_id
3917: into c_line_num,c_item_id, c_job_id, c_org_id
3918: from po_lines_all
3919: where po_line_id = p_loc_to.po_line_id;
3920:
3921: if (c_item_id is not null) then
3922: c_item := get_item(c_item_id, c_org_id);

Line 4729: from po_lines_all

4725: --get the line number using line id
4726:
4727: select line_num,item_id
4728: into c_line_num,c_item_id
4729: from po_lines_all
4730: where po_line_id = p_dist_to.po_line_id;
4731:
4732: --get the shipment number using line location id
4733:

Line 5120: * p_job_id job_id from po_lines_all

5116: * PURPOSE
5117: * Resolves the job name
5118: *
5119: * ARGUMENTS
5120: * p_job_id job_id from po_lines_all
5121: *
5122: * NOTES
5123: * Return NULL if no matching records were found.
5124: *

Line 5164: * p_item_id item_id from po_lines_all

5160: * PURPOSE
5161: * Resolves the item name
5162: *
5163: * ARGUMENTS
5164: * p_item_id item_id from po_lines_all
5165: * p_org_id org_id from po_lines_all
5166: *
5167: * NOTES
5168: * Return NULL if no matching records were found.

Line 5165: * p_org_id org_id from po_lines_all

5161: * Resolves the item name
5162: *
5163: * ARGUMENTS
5164: * p_item_id item_id from po_lines_all
5165: * p_org_id org_id from po_lines_all
5166: *
5167: * NOTES
5168: * Return NULL if no matching records were found.
5169: *