APPS.POS_REVISION_DIFFERENCES dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1264: FROM po_line_locations_archive_all plla1

1260: current_header_id NUMBER,
1261: current_release_id NUMBER,
1262: current_revision_num NUMBER ) IS
1263: SELECT *
1264: FROM po_line_locations_archive_all plla1
1265: WHERE po_header_id = current_header_id
1266: AND NVL( po_release_id, -99 ) = current_release_id
1267: AND revision_num = (
1268: SELECT MAX( revision_num )

Line 1269: FROM po_line_locations_archive_all plla2

1265: WHERE po_header_id = current_header_id
1266: AND NVL( po_release_id, -99 ) = current_release_id
1267: AND revision_num = (
1268: SELECT MAX( revision_num )
1269: FROM po_line_locations_archive_all plla2
1270: WHERE
1271: revision_num <= current_revision_num
1272: AND plla2.line_location_id = plla1.line_location_id
1273: );

Line 1275: v_loc_from po_line_locations_archive_all%ROWTYPE;

1271: revision_num <= current_revision_num
1272: AND plla2.line_location_id = plla1.line_location_id
1273: );
1274:
1275: v_loc_from po_line_locations_archive_all%ROWTYPE;
1276: v_loc_to po_line_locations_archive_all%ROWTYPE;
1277:
1278: v_previous_revision_num NUMBER;
1279: v_progress VARCHAR2(3);

Line 1276: v_loc_to po_line_locations_archive_all%ROWTYPE;

1272: AND plla2.line_location_id = plla1.line_location_id
1273: );
1274:
1275: v_loc_from po_line_locations_archive_all%ROWTYPE;
1276: v_loc_to po_line_locations_archive_all%ROWTYPE;
1277:
1278: v_previous_revision_num NUMBER;
1279: v_progress VARCHAR2(3);
1280:

Line 1313: FROM po_line_locations_archive_all

1309:
1310: v_progress := '210';
1311: SELECT *
1312: INTO v_loc_from
1313: FROM po_line_locations_archive_all
1314: WHERE
1315: revision_num = (
1316: SELECT MAX( revision_num )
1317: FROM po_line_locations_archive_all

Line 1317: FROM po_line_locations_archive_all

1313: FROM po_line_locations_archive_all
1314: WHERE
1315: revision_num = (
1316: SELECT MAX( revision_num )
1317: FROM po_line_locations_archive_all
1318: WHERE
1319: revision_num <=
1320: v_previous_revision_num
1321: AND line_location_id =

Line 2049: FROM po_line_locations_archive_all plla1

2045: current_line_id NUMBER,
2046: current_release_id NUMBER
2047: ) IS
2048: SELECT *
2049: FROM po_line_locations_archive_all plla1
2050: WHERE
2051: po_line_id = current_line_id
2052: AND NVL( po_release_id, -99 ) = current_release_id
2053: AND revision_num = (

Line 2055: FROM po_line_locations_archive_all plla2

2051: po_line_id = current_line_id
2052: AND NVL( po_release_id, -99 ) = current_release_id
2053: AND revision_num = (
2054: SELECT MAX( revision_num )
2055: FROM po_line_locations_archive_all plla2
2056: WHERE
2057: revision_num <= p_revision_num
2058: AND plla2.line_location_id = plla1.line_location_id
2059: );

Line 2061: v_loc_from po_line_locations_archive_all%ROWTYPE;

2057: revision_num <= p_revision_num
2058: AND plla2.line_location_id = plla1.line_location_id
2059: );
2060:
2061: v_loc_from po_line_locations_archive_all%ROWTYPE;
2062: v_loc_to po_line_locations_archive_all%ROWTYPE;
2063:
2064: v_previous_revision_num NUMBER;
2065: v_progress VARCHAR2(3);

Line 2062: v_loc_to po_line_locations_archive_all%ROWTYPE;

2058: AND plla2.line_location_id = plla1.line_location_id
2059: );
2060:
2061: v_loc_from po_line_locations_archive_all%ROWTYPE;
2062: v_loc_to po_line_locations_archive_all%ROWTYPE;
2063:
2064: v_previous_revision_num NUMBER;
2065: v_progress VARCHAR2(3);
2066:

Line 2100: FROM po_line_locations_archive_all

2096:
2097: v_progress := '410';
2098: SELECT *
2099: INTO v_loc_from
2100: FROM po_line_locations_archive_all
2101: WHERE
2102: line_location_id = v_loc_to.line_location_id
2103: AND revision_num =
2104: (

Line 2106: FROM po_line_locations_archive_all

2102: line_location_id = v_loc_to.line_location_id
2103: AND revision_num =
2104: (
2105: SELECT MAX(revision_num)
2106: FROM po_line_locations_archive_all
2107: WHERE
2108: revision_num <=
2109: v_previous_revision_num
2110: AND line_location_id =