APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES_ARCHIVE_ALL

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