APPS.POS_COMPARE_REVISIONS dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 3866: p_loc_from in po_line_locations_archive_all%ROWTYPE,

3862: * 14-FEB-2003 Amitabh Mitra Added start_date and end_date
3863: * for blankets
3864: ********************************************************************/
3865: PROCEDURE compare_locations(
3866: p_loc_from in po_line_locations_archive_all%ROWTYPE,
3867: p_loc_to in po_line_locations_archive_all%ROWTYPE,
3868: p_sequence IN NUMBER
3869: ) AS
3870:

Line 3867: p_loc_to in po_line_locations_archive_all%ROWTYPE,

3863: * for blankets
3864: ********************************************************************/
3865: PROCEDURE compare_locations(
3866: p_loc_from in po_line_locations_archive_all%ROWTYPE,
3867: p_loc_to in po_line_locations_archive_all%ROWTYPE,
3868: p_sequence IN NUMBER
3869: ) AS
3870:
3871: /* Constant variables to pass for insert_changes */

Line 5233: from po_line_locations_archive_all PLL

5229: x_advance_amt NUMBER := 0;
5230:
5231: CURSOR l_advance_amt_csr IS
5232: select PLL.amount
5233: from po_line_locations_archive_all PLL
5234: where PLL.po_line_id = p_po_line_id
5235: and PLL.payment_type = 'ADVANCE'
5236: and PLL.shipment_type = 'PREPAYMENT'
5237: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

Line 5237: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

5233: from po_line_locations_archive_all PLL
5234: where PLL.po_line_id = p_po_line_id
5235: and PLL.payment_type = 'ADVANCE'
5236: and PLL.shipment_type = 'PREPAYMENT'
5237: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1
5238: where PLL1.line_location_id = PLL.line_location_id
5239: and PLL1.revision_num <= p_revision_num);
5240: BEGIN
5241:

Line 5289: from PO_LINE_LOCATIONS_ARCHIVE_ALL PLL,

5285: CURSOR l_value_percent_csr IS
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'

Line 5294: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

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