DBA Data[Home] [Help]

APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES_ALL

Line 545: FROM po_lines_all

541: v_progress := '110';
542:
543: SELECT line_num
544: INTO v_line_num
545: FROM po_lines_all
546: WHERE po_line_id = p_line_id;
547:
548: RETURN v_line_num;
549:

Line 2204: FROM po_headers_all poh,po_lines_all pol

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

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

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

Line 3914: from po_lines_all

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

Line 4723: from po_lines_all

4719: --get the line number using line id
4720:
4721: select line_num,item_id
4722: into c_line_num,c_item_id
4723: from po_lines_all
4724: where po_line_id = p_dist_to.po_line_id;
4725:
4726: --get the shipment number using line location id
4727:

Line 5114: * p_job_id job_id from po_lines_all

5110: * PURPOSE
5111: * Resolves the job name
5112: *
5113: * ARGUMENTS
5114: * p_job_id job_id from po_lines_all
5115: *
5116: * NOTES
5117: * Return NULL if no matching records were found.
5118: *

Line 5158: * p_item_id item_id from po_lines_all

5154: * PURPOSE
5155: * Resolves the item name
5156: *
5157: * ARGUMENTS
5158: * p_item_id item_id from po_lines_all
5159: * p_org_id org_id from po_lines_all
5160: *
5161: * NOTES
5162: * Return NULL if no matching records were found.

Line 5159: * p_org_id org_id from po_lines_all

5155: * Resolves the item name
5156: *
5157: * ARGUMENTS
5158: * p_item_id item_id from po_lines_all
5159: * p_org_id org_id from po_lines_all
5160: *
5161: * NOTES
5162: * Return NULL if no matching records were found.
5163: *