APPS.PO_REVISION_DIFFERENCES dependencies on PO_LINE_LOCATIONS_ARCHIVE

Line 742: FROM po_line_locations_archive plla1

738: current_header_id NUMBER,
739: current_release_id NUMBER,
740: current_revision_num NUMBER ) IS
741: SELECT *
742: FROM po_line_locations_archive plla1
743: WHERE po_header_id = current_header_id
744: AND NVL( po_release_id, -99 ) = current_release_id
745: AND revision_num = (
746: SELECT MAX( revision_num )

Line 747: FROM po_line_locations_archive plla2

743: WHERE po_header_id = current_header_id
744: AND NVL( po_release_id, -99 ) = current_release_id
745: AND revision_num = (
746: SELECT MAX( revision_num )
747: FROM po_line_locations_archive plla2
748: WHERE
749: revision_num <= current_revision_num
750: AND plla2.line_location_id = plla1.line_location_id
751: );

Line 753: v_loc_from po_line_locations_archive%ROWTYPE;

749: revision_num <= current_revision_num
750: AND plla2.line_location_id = plla1.line_location_id
751: );
752:
753: v_loc_from po_line_locations_archive%ROWTYPE;
754: v_loc_to po_line_locations_archive%ROWTYPE;
755:
756: v_previous_revision_num NUMBER;
757: v_progress VARCHAR2(3);

Line 754: v_loc_to po_line_locations_archive%ROWTYPE;

750: AND plla2.line_location_id = plla1.line_location_id
751: );
752:
753: v_loc_from po_line_locations_archive%ROWTYPE;
754: v_loc_to po_line_locations_archive%ROWTYPE;
755:
756: v_previous_revision_num NUMBER;
757: v_progress VARCHAR2(3);
758:

Line 791: FROM po_line_locations_archive

787:
788: v_progress := '210';
789: SELECT *
790: INTO v_loc_from
791: FROM po_line_locations_archive
792: WHERE
793: revision_num = (
794: SELECT MAX( revision_num )
795: FROM po_line_locations_archive

Line 795: FROM po_line_locations_archive

791: FROM po_line_locations_archive
792: WHERE
793: revision_num = (
794: SELECT MAX( revision_num )
795: FROM po_line_locations_archive
796: WHERE
797: revision_num <=
798: v_previous_revision_num
799: AND line_location_id =

Line 1527: FROM po_line_locations_archive plla1

1523: current_line_id NUMBER,
1524: current_release_id NUMBER
1525: ) IS
1526: SELECT *
1527: FROM po_line_locations_archive plla1
1528: WHERE
1529: po_line_id = current_line_id
1530: AND NVL( po_release_id, -99 ) = current_release_id
1531: AND revision_num = (

Line 1533: FROM po_line_locations_archive plla2

1529: po_line_id = current_line_id
1530: AND NVL( po_release_id, -99 ) = current_release_id
1531: AND revision_num = (
1532: SELECT MAX( revision_num )
1533: FROM po_line_locations_archive plla2
1534: WHERE
1535: revision_num <= p_revision_num
1536: AND plla2.line_location_id = plla1.line_location_id
1537: );

Line 1539: v_loc_from po_line_locations_archive%ROWTYPE;

1535: revision_num <= p_revision_num
1536: AND plla2.line_location_id = plla1.line_location_id
1537: );
1538:
1539: v_loc_from po_line_locations_archive%ROWTYPE;
1540: v_loc_to po_line_locations_archive%ROWTYPE;
1541:
1542: v_previous_revision_num NUMBER;
1543: v_progress VARCHAR2(3);

Line 1540: v_loc_to po_line_locations_archive%ROWTYPE;

1536: AND plla2.line_location_id = plla1.line_location_id
1537: );
1538:
1539: v_loc_from po_line_locations_archive%ROWTYPE;
1540: v_loc_to po_line_locations_archive%ROWTYPE;
1541:
1542: v_previous_revision_num NUMBER;
1543: v_progress VARCHAR2(3);
1544:

Line 1578: FROM po_line_locations_archive

1574:
1575: v_progress := '410';
1576: SELECT *
1577: INTO v_loc_from
1578: FROM po_line_locations_archive
1579: WHERE
1580: line_location_id = v_loc_to.line_location_id
1581: AND revision_num =
1582: (

Line 1584: FROM po_line_locations_archive

1580: line_location_id = v_loc_to.line_location_id
1581: AND revision_num =
1582: (
1583: SELECT MAX(revision_num)
1584: FROM po_line_locations_archive
1585: WHERE
1586: revision_num <=
1587: v_previous_revision_num
1588: AND line_location_id =