APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES

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

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

Line 540: v_line_num po_lines.line_num%TYPE;

536: ********************************************************************/
537: FUNCTION get_source_quotation_line( p_line_id in number )
538: RETURN VARCHAR2 AS
539:
540: v_line_num po_lines.line_num%TYPE;
541: v_progress varchar2(3);
542:
543: BEGIN
544:

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

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

Line 2637: p_line_to in po_lines_archive_all%ROWTYPE,

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

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

Line 5290: PO_LINES_ARCHIVE_ALL POL

5286: select ROUND(DECODE(PLL.matching_basis,
5287: 'AMOUNT', (NVL(PLL.amount, 0)/POL.amount)*100,
5288: 'QUANTITY', (NVL(PLL.price_override, 0)/POL.unit_price)*100))
5289: from PO_LINE_LOCATIONS_ARCHIVE_ALL PLL,
5290: PO_LINES_ARCHIVE_ALL POL
5291: where PLL.po_line_id = POL.po_line_id
5292: and PLL.line_location_id = p_po_line_location_id
5293: and PLL.payment_type = 'MILESTONE'
5294: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

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

5293: and PLL.payment_type = 'MILESTONE'
5294: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1
5295: where PLL1.line_location_id = PLL.line_location_id
5296: and PLL1.revision_num <= p_revision_num)
5297: and POL.revision_num = (select max(revision_num) from po_lines_archive_all POL1
5298: where POL1.po_line_id = POL.po_line_id
5299: and POL1.revision_num <= p_revision_num);
5300:
5301: BEGIN