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.POS_REVISION_DIFFERENCES dependencies on PO_RELEASES_ARCHIVE_ALL

Line 15: * PO_RELEASES_ARCHIVE_ALL table

11: * ARGUMENTS
12: * p_header_id Unique identified for the current PO in
13: * PO_HEADERS_ARCHIVE_ALL table
14: * p_release_id Unique identifier for the PO release in
15: * PO_RELEASES_ARCHIVE_ALL table
16: * p_revision_num Current PO revision number
17: * p_dummy_in4 Not required
18: * p_dummy_in5 Not required
19: * p_dummy_in6 Not required

Line 110: * PO_RELEASES_ARCHIVE_ALL table

106: * ARGUMENTS
107: * p_header_id Unique identified for the current PO in
108: * PO_HEADERS_ARCHIVE_ALL table
109: * p_release_id Unique identifier for the PO release in
110: * PO_RELEASES_ARCHIVE_ALL table
111: * p_revision_num Current PO revision number
112: * p_dummy_in4 Not required
113: * p_dummy_in5 Not required
114: * p_dummy_in6 Not required

Line 207: * PO_RELEASES_ARCHIVE_ALL table

203: * ARGUMENTS
204: * p_header_id Unique identified for the current PO in
205: * PO_HEADERS_ARCHIVE_ALL table
206: * p_release_id Unique identifier for the PO release in
207: * PO_RELEASES_ARCHIVE_ALL table
208: * p_revision_num Current PO revision number
209: * p_dummy_in4 Not required
210: * p_dummy_in5 Not required
211: * p_dummy_in6 Not required

Line 303: * PO_RELEASES_ARCHIVE_ALL table

299: * ARGUMENTS
300: * p_header_id Unique identified for the current PO in
301: * PO_HEADERS_ARCHIVE_ALL table
302: * p_release_id Unique identifier for the PO release in
303: * PO_RELEASES_ARCHIVE_ALL table
304: * p_revision_num Current PO revision number
305: * p_dummy_in4 Not required
306: * p_dummy_in5 Not required
307: * p_dummy_in6 Not required

Line 399: * PO_RELEASES_ARCHIVE_ALL table

395: * ARGUMENTS
396: * p_header_id Unique identified for the current PO in
397: * PO_HEADERS_ARCHIVE_ALL table
398: * p_release_id Unique identifier for the PO release in
399: * PO_RELEASES_ARCHIVE_ALL table
400: * p_revision_num Current PO revision number
401: * p_comparison_flag Indicator to compare the PO with the previous
402: * or original revision
403: * p_sequence_num Sequence number to identify the comparison

Line 561: * PO_RELEASES_ARCHIVE_ALL table

557: * ARGUMENTS
558: * p_header_id Unique identified for the PO in
559: * PO_HEADERS_ARCHIVE_ALL table
560: * p_release_id Unique identifier for the PO release in
561: * PO_RELEASES_ARCHIVE_ALL table
562: * p_revision_num Current PO revision number
563: * p_comparison_flag Indicator to compare the PO with the previous
564: * or original revision
565: * p_sequence_num Sequence number to identify the comparison

Line 587: v_release_from po_releases_archive_all%ROWTYPE;

583:
584: v_header_from po_headers_archive_all%ROWTYPE;
585: v_header_to po_headers_archive_all%ROWTYPE;
586:
587: v_release_from po_releases_archive_all%ROWTYPE;
588: v_release_to po_releases_archive_all%ROWTYPE;
589:
590: v_previous_revision_num NUMBER;
591: v_progress VARCHAR2(3);

Line 588: v_release_to po_releases_archive_all%ROWTYPE;

584: v_header_from po_headers_archive_all%ROWTYPE;
585: v_header_to po_headers_archive_all%ROWTYPE;
586:
587: v_release_from po_releases_archive_all%ROWTYPE;
588: v_release_to po_releases_archive_all%ROWTYPE;
589:
590: v_previous_revision_num NUMBER;
591: v_progress VARCHAR2(3);
592: l_msg_data varchar2(2000);

Line 683: FROM po_releases_archive_all

679:
680: v_progress := '140';
681: SELECT *
682: INTO v_release_to
683: FROM po_releases_archive_all
684: WHERE
685: po_release_id = p_release_id
686: AND revision_num = p_revision_num;
687:

Line 699: FROM po_releases_archive_all

695:
696: v_progress := '150';
697: SELECT *
698: INTO v_release_from
699: FROM po_releases_archive_all
700: WHERE
701: po_release_id = p_release_id
702: AND revision_num = v_previous_revision_num;
703:

Line 744: * PO_RELEASES_ARCHIVE_ALL table

740: * ARGUMENTS
741: * p_header_id Unique identified for the PO in
742: * PO_HEADERS_ARCHIVE_ALL table
743: * p_release_id Unique identifier for the PO release in
744: * PO_RELEASES_ARCHIVE_ALL table
745: * p_revision_num Current PO revision number
746: * p_comparison_flag Indicator to compare the PO with the previous
747: * or original revision
748: * p_sequence_num Sequence number to identify the comparison

Line 866: * PO_RELEASES_ARCHIVE_ALL table

862: * ARGUMENTS
863: * p_header_id Unique identified for the PO in
864: * PO_HEADERS_ARCHIVE_ALL table
865: * p_release_id Unique identifier for the PO release in
866: * PO_RELEASES_ARCHIVE_ALL table
867: * p_revision_num Current PO revision number
868: * p_comparison_flag Indicator to compare the PO with the previous
869: * or original revision
870: * p_sequence_num Sequence number to identify the comparison

Line 1233: * PO_RELEASES_ARCHIVE_ALL table

1229: * ARGUMENTS
1230: * p_header_id Unique identified for the PO in
1231: * PO_HEADERS_ARCHIVE_ALL table
1232: * p_release_id Unique identifier for the PO release in
1233: * PO_RELEASES_ARCHIVE_ALL table
1234: * p_revision_num Current PO revision number
1235: * p_comparison_flag Indicator to compare the PO with the previous
1236: * or original revision
1237: * p_sequence_num Sequence number to identify the comparison

Line 1367: * PO_RELEASES_ARCHIVE_ALL table

1363: * ARGUMENTS
1364: * p_header_id Unique identified for the PO in
1365: * PO_HEADERS_ARCHIVE_ALL table
1366: * p_release_id Unique identifier for the PO release in
1367: * PO_RELEASES_ARCHIVE_ALL table
1368: * p_revision_num Current PO revision number
1369: * p_comparison_flag Indicator to compare the PO with the previous
1370: * or original revision
1371: * p_sequence_num Sequence number to identify the comparison

Line 1500: * PO_RELEASES_ARCHIVE_ALL table

1496: * ARGUMENTS
1497: * p_line_id Unique identified for the current PO line in
1498: * PO_LINES_ARCHIVE_ALL table
1499: * p_release_id Unique identifier for the PO release in
1500: * PO_RELEASES_ARCHIVE_ALL table
1501: * p_revision_num Current PO line revision number
1502: * p_dummy_in4 Not required
1503: * p_dummy_in5 Not required
1504: * p_dummy_in6 Not required

Line 1598: * PO_RELEASES_ARCHIVE_ALL table

1594: * ARGUMENTS
1595: * p_line_id Unique identified for the current PO line in
1596: * PO_LINES_ARCHIVE_ALL table
1597: * p_release_id Unique identifier for the PO release in
1598: * PO_RELEASES_ARCHIVE_ALL table
1599: * p_revision_num Current PO line revision number
1600: * p_dummy_in4 Not required
1601: * p_dummy_in5 Not required
1602: * p_dummy_in6 Not required

Line 1696: * PO_RELEASES_ARCHIVE_ALL table

1692: * ARGUMENTS
1693: * p_line_id Unique identified for the current PO line in
1694: * PO_LINES_ARCHIVE_ALL table
1695: * p_release_id Unique identifier for the PO release in
1696: * PO_RELEASES_ARCHIVE_ALL table
1697: * p_revision_num Current PO line revision number
1698: * p_dummy_in4 Not required
1699: * p_dummy_in5 Not required
1700: * p_dummy_in6 Not required

Line 1796: * PO_RELEASES_ARCHIVE_ALL table

1792: * ARGUMENTS
1793: * p_line_id Unique identified for the current PO line in
1794: * PO_LINES_ARCHIVE_ALL table
1795: * p_release_id Unique identifier for the PO release in
1796: * PO_RELEASES_ARCHIVE_ALL table
1797: * p_revision_num Current PO line revision number
1798: * p_comparison_flag Indicator to compare the PO with the previous
1799: * or original revision
1800: * p_sequence_num Sequence number to identify the comparison

Line 2018: * in PO_RELEASES_ARCHIVE_ALL table

2014: * ARGUMENTS
2015: * p_line_id Unique identified for the current PO line in
2016: * PO_LINES_ARCHIVE_ALL table
2017: * p_release_id Unique identified for the current PO release
2018: * in PO_RELEASES_ARCHIVE_ALL table
2019: * p_revision_num Current PO line revision number
2020: * p_comparison_flag Indicator to compare the PO with the previous
2021: * or original revision
2022: * p_sequence_num Sequence number to identify the comparison

Line 2153: * in PO_RELEASES_ARCHIVE_ALL table

2149: * ARGUMENTS
2150: * p_line_id Unique identified for the current PO line in
2151: * PO_LINES_ARCHIVE_ALL table
2152: * p_release_id Unique identified for the current PO release
2153: * in PO_RELEASES_ARCHIVE_ALL table
2154: * p_revision_num Current PO line revision number
2155: * p_comparison_flag Indicator to compare the PO with the previous
2156: * or original revision
2157: * p_sequence_num Sequence number to identify the comparison