APPS.POS_REVISION_DIFFERENCES dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 1399: FROM po_distributions_archive_all pda1

1395: current_release_id NUMBER,
1396: current_revision_num NUMBER
1397: ) IS
1398: SELECT *
1399: FROM po_distributions_archive_all pda1
1400: WHERE
1401: po_header_id = current_header_id
1402: AND NVL( po_release_id, -99 ) = current_release_id
1403: AND revision_num = (

Line 1405: FROM po_distributions_archive_all pda2

1401: po_header_id = current_header_id
1402: AND NVL( po_release_id, -99 ) = current_release_id
1403: AND revision_num = (
1404: SELECT MAX( revision_num )
1405: FROM po_distributions_archive_all pda2
1406: WHERE
1407: revision_num <= current_revision_num
1408: AND pda2.po_distribution_id = pda1.po_distribution_id
1409: );

Line 1411: v_dist_from po_distributions_archive_all%ROWTYPE;

1407: revision_num <= current_revision_num
1408: AND pda2.po_distribution_id = pda1.po_distribution_id
1409: );
1410:
1411: v_dist_from po_distributions_archive_all%ROWTYPE;
1412: v_dist_to po_distributions_archive_all%ROWTYPE;
1413:
1414: v_previous_revision_num NUMBER;
1415: v_progress VARCHAR2(3);

Line 1412: v_dist_to po_distributions_archive_all%ROWTYPE;

1408: AND pda2.po_distribution_id = pda1.po_distribution_id
1409: );
1410:
1411: v_dist_from po_distributions_archive_all%ROWTYPE;
1412: v_dist_to po_distributions_archive_all%ROWTYPE;
1413:
1414: v_previous_revision_num NUMBER;
1415: v_progress VARCHAR2(3);
1416:

Line 1449: FROM po_distributions_archive_all

1445:
1446: v_progress := '240';
1447: SELECT *
1448: INTO v_dist_from
1449: FROM po_distributions_archive_all
1450: WHERE
1451: revision_num = (
1452: SELECT MAX( revision_num )
1453: FROM po_distributions_archive_all

Line 1453: FROM po_distributions_archive_all

1449: FROM po_distributions_archive_all
1450: WHERE
1451: revision_num = (
1452: SELECT MAX( revision_num )
1453: FROM po_distributions_archive_all
1454: WHERE revision_num <=
1455: v_previous_revision_num
1456: AND po_distribution_id =
1457: v_dist_to.po_distribution_id

Line 2185: FROM po_distributions_archive_all pda1

2181: current_line_id number,
2182: current_release_id number
2183: ) IS
2184: SELECT *
2185: FROM po_distributions_archive_all pda1
2186: WHERE
2187: po_line_id = current_line_id
2188: AND NVL( po_release_id, -99 ) = current_release_id
2189: AND revision_num = (

Line 2191: FROM po_distributions_archive_all pda2

2187: po_line_id = current_line_id
2188: AND NVL( po_release_id, -99 ) = current_release_id
2189: AND revision_num = (
2190: SELECT MAX( revision_num )
2191: FROM po_distributions_archive_all pda2
2192: WHERE
2193: revision_num <= p_revision_num
2194: AND pda2.po_distribution_id = pda1.po_distribution_id
2195: );

Line 2197: v_dist_from po_distributions_archive_all%ROWTYPE;

2193: revision_num <= p_revision_num
2194: AND pda2.po_distribution_id = pda1.po_distribution_id
2195: );
2196:
2197: v_dist_from po_distributions_archive_all%ROWTYPE;
2198: v_dist_to po_distributions_archive_all%ROWTYPE;
2199:
2200: v_previous_revision_num NUMBER;
2201: v_progress VARCHAR2(3);

Line 2198: v_dist_to po_distributions_archive_all%ROWTYPE;

2194: AND pda2.po_distribution_id = pda1.po_distribution_id
2195: );
2196:
2197: v_dist_from po_distributions_archive_all%ROWTYPE;
2198: v_dist_to po_distributions_archive_all%ROWTYPE;
2199:
2200: v_previous_revision_num NUMBER;
2201: v_progress VARCHAR2(3);
2202:

Line 2236: FROM po_distributions_archive_all

2232:
2233: v_progress := '440';
2234: SELECT *
2235: INTO v_dist_from
2236: FROM po_distributions_archive_all
2237: WHERE
2238: po_distribution_id =
2239: v_dist_to.po_distribution_id
2240: AND revision_num = (

Line 2242: FROM po_distributions_archive_all

2238: po_distribution_id =
2239: v_dist_to.po_distribution_id
2240: AND revision_num = (
2241: SELECT MAX( revision_num )
2242: FROM po_distributions_archive_all
2243: WHERE revision_num <=
2244: v_previous_revision_num
2245: AND po_distribution_id =
2246: v_dist_to.po_distribution_id