APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES

Line 525: * p_line_id Unique identifier for PO line in PO_LINES table.

521: * PURPOSE
522: * Resolves the source quotation PO line number.
523: *
524: * ARGUMENTS
525: * p_line_id Unique identifier for PO line in PO_LINES table.
526: *
527: * NOTES
528: * Return NULL if no matching records were found.
529: *

Line 536: v_line_num po_lines.line_num%TYPE;

532: ********************************************************************/
533: FUNCTION get_source_quotation_line( p_line_id in number )
534: RETURN VARCHAR2 AS
535:
536: v_line_num po_lines.line_num%TYPE;
537: v_progress varchar2(3);
538:
539: BEGIN
540:

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 2632: p_line_from in po_lines_archive_all%ROWTYPE,

2628: * agreed, and amount agreed.
2629: * 08-SEP-97 Rami Haddad Compare closed code
2630: ********************************************************************/
2631: PROCEDURE compare_lines(
2632: p_line_from in po_lines_archive_all%ROWTYPE,
2633: p_line_to in po_lines_archive_all%ROWTYPE,
2634: p_sequence IN NUMBER
2635: ) AS
2636:

Line 2633: p_line_to in po_lines_archive_all%ROWTYPE,

2629: * 08-SEP-97 Rami Haddad Compare closed code
2630: ********************************************************************/
2631: PROCEDURE compare_lines(
2632: p_line_from in po_lines_archive_all%ROWTYPE,
2633: p_line_to in po_lines_archive_all%ROWTYPE,
2634: p_sequence IN NUMBER
2635: ) AS
2636:
2637: /*

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: *

Line 5284: PO_LINES_ARCHIVE_ALL POL

5280: select ROUND(DECODE(PLL.matching_basis,
5281: 'AMOUNT', (NVL(PLL.amount, 0)/POL.amount)*100,
5282: 'QUANTITY', (NVL(PLL.price_override, 0)/POL.unit_price)*100))
5283: from PO_LINE_LOCATIONS_ARCHIVE_ALL PLL,
5284: PO_LINES_ARCHIVE_ALL POL
5285: where PLL.po_line_id = POL.po_line_id
5286: and PLL.line_location_id = p_po_line_location_id
5287: and PLL.payment_type = 'MILESTONE'
5288: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

Line 5291: and POL.revision_num = (select max(revision_num) from po_lines_archive_all POL1

5287: and PLL.payment_type = 'MILESTONE'
5288: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1
5289: where PLL1.line_location_id = PLL.line_location_id
5290: and PLL1.revision_num <= p_revision_num)
5291: and POL.revision_num = (select max(revision_num) from po_lines_archive_all POL1
5292: where POL1.po_line_id = POL.po_line_id
5293: and POL1.revision_num <= p_revision_num);
5294:
5295: BEGIN