APPS.POS_COMPARE_REVISIONS dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 3862: p_loc_from in po_line_locations_archive_all%ROWTYPE,

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

Line 3863: p_loc_to in po_line_locations_archive_all%ROWTYPE,

3859: * for blankets
3860: ********************************************************************/
3861: PROCEDURE compare_locations(
3862: p_loc_from in po_line_locations_archive_all%ROWTYPE,
3863: p_loc_to in po_line_locations_archive_all%ROWTYPE,
3864: p_sequence IN NUMBER
3865: ) AS
3866:
3867: /* Constant variables to pass for insert_changes */

Line 5227: from po_line_locations_archive_all PLL

5223: x_advance_amt NUMBER := 0;
5224:
5225: CURSOR l_advance_amt_csr IS
5226: select PLL.amount
5227: from po_line_locations_archive_all PLL
5228: where PLL.po_line_id = p_po_line_id
5229: and PLL.payment_type = 'ADVANCE'
5230: and PLL.shipment_type = 'PREPAYMENT'
5231: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1

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

5227: from po_line_locations_archive_all PLL
5228: where PLL.po_line_id = p_po_line_id
5229: and PLL.payment_type = 'ADVANCE'
5230: and PLL.shipment_type = 'PREPAYMENT'
5231: and PLL.revision_num = (select max(revision_num) from po_line_locations_archive_all PLL1
5232: where PLL1.line_location_id = PLL.line_location_id
5233: and PLL1.revision_num <= p_revision_num);
5234: BEGIN
5235:

Line 5283: from PO_LINE_LOCATIONS_ARCHIVE_ALL PLL,

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

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

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