APPS.POS_COMPARE_REVISIONS dependencies on PO_LINES_ARCHIVE_ALL

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