eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REVISION_DIFFERENCES dependencies on PO_LINES_ARCHIVE

Line 609: FROM po_lines_archive pla1

605: CURSOR current_lines_cursor(
606: current_header_id NUMBER,
607: current_revision_num NUMBER ) IS
608: SELECT *
609: FROM po_lines_archive pla1
610: WHERE
611: po_header_id = current_header_id
612: AND revision_num = (
613: SELECT MAX( revision_num )

Line 614: FROM po_lines_archive pla2

610: WHERE
611: po_header_id = current_header_id
612: AND revision_num = (
613: SELECT MAX( revision_num )
614: FROM po_lines_archive pla2
615: WHERE
616: revision_num <= current_revision_num
617: AND pla2.po_line_id = pla1.po_line_id
618: );

Line 620: v_line_to po_lines_archive%ROWTYPE;

616: revision_num <= current_revision_num
617: AND pla2.po_line_id = pla1.po_line_id
618: );
619:
620: v_line_to po_lines_archive%ROWTYPE;
621: v_line_from po_lines_archive%ROWTYPE;
622:
623: v_previous_revision_num NUMBER;
624: v_progress VARCHAR2(3);

Line 621: v_line_from po_lines_archive%ROWTYPE;

617: AND pla2.po_line_id = pla1.po_line_id
618: );
619:
620: v_line_to po_lines_archive%ROWTYPE;
621: v_line_from po_lines_archive%ROWTYPE;
622:
623: v_previous_revision_num NUMBER;
624: v_progress VARCHAR2(3);
625:

Line 658: FROM po_lines_archive

654:
655: v_progress := '180';
656: SELECT *
657: INTO v_line_from
658: FROM po_lines_archive
659: WHERE
660: revision_num = (
661: SELECT MAX( revision_num )
662: FROM po_lines_archive

Line 662: FROM po_lines_archive

658: FROM po_lines_archive
659: WHERE
660: revision_num = (
661: SELECT MAX( revision_num )
662: FROM po_lines_archive
663: WHERE
664: revision_num <=
665: v_previous_revision_num
666: AND po_line_id = v_line_to.po_line_id

Line 976: * PO_LINES_ARCHIVE_ALL table

972: * Call the procedure COMPARE_PO_LINE with ALL as comparison flag.
973: *
974: * ARGUMENTS
975: * p_line_id Unique identified for the current PO line in
976: * PO_LINES_ARCHIVE_ALL table
977: * p_release_id Unique identifier for the PO release in
978: * PO_RELEASES_ARCHIVE_ALL table
979: * p_revision_num Current PO line revision number
980: * p_dummy_in4 Not required

Line 1074: * PO_LINES_ARCHIVE_ALL table

1070: * flag.
1071: *
1072: * ARGUMENTS
1073: * p_line_id Unique identified for the current PO line in
1074: * PO_LINES_ARCHIVE_ALL table
1075: * p_release_id Unique identifier for the PO release in
1076: * PO_RELEASES_ARCHIVE_ALL table
1077: * p_revision_num Current PO line revision number
1078: * p_dummy_in4 Not required

Line 1172: * PO_LINES_ARCHIVE_ALL table

1168: * flag.
1169: *
1170: * ARGUMENTS
1171: * p_line_id Unique identified for the current PO line in
1172: * PO_LINES_ARCHIVE_ALL table
1173: * p_release_id Unique identifier for the PO release in
1174: * PO_RELEASES_ARCHIVE_ALL table
1175: * p_revision_num Current PO line revision number
1176: * p_dummy_in4 Not required

Line 1272: * PO_LINES_ARCHIVE_ALL table

1268: * revision---including all shipments, and distributions.
1269: *
1270: * ARGUMENTS
1271: * p_line_id Unique identified for the current PO line in
1272: * PO_LINES_ARCHIVE_ALL table
1273: * p_release_id Unique identifier for the PO release in
1274: * PO_RELEASES_ARCHIVE_ALL table
1275: * p_revision_num Current PO line revision number
1276: * p_comparison_flag Indicator to compare the PO with the previous

Line 1378: * PO_LINES_ARCHIVE_ALL table

1374: * revision---including all shipments, and distributions.
1375: *
1376: * ARGUMENTS
1377: * p_line_id Unique identified for the current PO line in
1378: * PO_LINES_ARCHIVE_ALL table
1379: * p_revision_num Current PO line revision number
1380: * p_comparison_flag Indicator to compare the PO with the previous
1381: * or original revision
1382: * p_sequence_num Sequence number to identify the comparison

Line 1405: v_line_to po_lines_archive%ROWTYPE;

1401: p_comparison_flag IN VARCHAR2,
1402: p_sequence_num IN NUMBER
1403: ) AS
1404:
1405: v_line_to po_lines_archive%ROWTYPE;
1406: v_line_from po_lines_archive%ROWTYPE;
1407:
1408: v_previous_revision_num NUMBER;
1409: v_progress VARCHAR2(3);

Line 1406: v_line_from po_lines_archive%ROWTYPE;

1402: p_sequence_num IN NUMBER
1403: ) AS
1404:
1405: v_line_to po_lines_archive%ROWTYPE;
1406: v_line_from po_lines_archive%ROWTYPE;
1407:
1408: v_previous_revision_num NUMBER;
1409: v_progress VARCHAR2(3);
1410:

Line 1422: FROM po_lines_archive

1418:
1419: IF p_comparison_flag = 'ORIGINAL' THEN
1420: SELECT MIN( revision_num )
1421: INTO v_previous_revision_num
1422: FROM po_lines_archive
1423: WHERE po_line_id = p_line_id;
1424: ELSE
1425: v_previous_revision_num := p_revision_num - 1;
1426: END IF;

Line 1433: FROM po_lines_archive pla1

1429:
1430: v_progress := '360';
1431: SELECT *
1432: INTO v_line_to
1433: FROM po_lines_archive pla1
1434: WHERE
1435: po_line_id = p_line_id
1436: AND revision_num = p_revision_num;
1437:

Line 1449: FROM po_lines_archive

1445:
1446: v_progress := '370';
1447: SELECT *
1448: INTO v_line_from
1449: FROM po_lines_archive
1450: WHERE
1451: po_line_id = p_line_id
1452: AND revision_num = (
1453: SELECT MAX( revision_num )

Line 1454: FROM po_lines_archive

1450: WHERE
1451: po_line_id = p_line_id
1452: AND revision_num = (
1453: SELECT MAX( revision_num )
1454: FROM po_lines_archive
1455: WHERE
1456: revision_num <= v_previous_revision_num
1457: AND po_line_id = p_line_id
1458: );

Line 1494: * PO_LINES_ARCHIVE_ALL table

1490: * revision---including all shipments, and distributions.
1491: *
1492: * ARGUMENTS
1493: * p_line_id Unique identified for the current PO line in
1494: * PO_LINES_ARCHIVE_ALL table
1495: * p_release_id Unique identified for the current PO release
1496: * in PO_RELEASES_ARCHIVE_ALL table
1497: * p_revision_num Current PO line revision number
1498: * p_comparison_flag Indicator to compare the PO with the previous

Line 1555: FROM po_lines_archive

1551:
1552: IF p_comparison_flag = 'ORIGINAL' THEN
1553: SELECT MIN( revision_num )
1554: INTO v_previous_revision_num
1555: FROM po_lines_archive
1556: WHERE po_line_id = p_line_id;
1557: ELSE
1558: v_previous_revision_num := p_revision_num - 1;
1559: END IF;

Line 1629: * PO_LINES_ARCHIVE_ALL table

1625: * revision.
1626: *
1627: * ARGUMENTS
1628: * p_line_id Unique identified for the current PO line in
1629: * PO_LINES_ARCHIVE_ALL table
1630: * p_release_id Unique identified for the current PO release
1631: * in PO_RELEASES_ARCHIVE_ALL table
1632: * p_revision_num Current PO line revision number
1633: * p_comparison_flag Indicator to compare the PO with the previous

Line 1691: FROM po_lines_archive

1687:
1688: IF p_comparison_flag = 'ORIGINAL' THEN
1689: SELECT MIN( revision_num )
1690: INTO v_previous_revision_num
1691: FROM po_lines_archive
1692: WHERE po_line_id = p_line_id;
1693: ELSE
1694: v_previous_revision_num := p_revision_num - 1;
1695: END IF;