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_RELEASES_ARCHIVE

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 305: * PO_RELEASES_ARCHIVE_ALL table

301: * ARGUMENTS
302: * p_header_id Unique identified for the current PO in
303: * PO_HEADERS_ARCHIVE_ALL table
304: * p_release_id Unique identifier for the PO release in
305: * PO_RELEASES_ARCHIVE_ALL table
306: * p_revision_num Current PO revision number
307: * p_comparison_flag Indicator to compare the PO with the previous
308: * or original revision
309: * p_sequence_num Sequence number to identify the comparison

Line 425: * PO_RELEASES_ARCHIVE_ALL table

421: * ARGUMENTS
422: * p_header_id Unique identified for the PO in
423: * PO_HEADERS_ARCHIVE_ALL table
424: * p_release_id Unique identifier for the PO release in
425: * PO_RELEASES_ARCHIVE_ALL table
426: * p_revision_num Current PO revision number
427: * p_comparison_flag Indicator to compare the PO with the previous
428: * or original revision
429: * p_sequence_num Sequence number to identify the comparison

Line 450: v_release_from po_releases_archive%ROWTYPE;

446:
447: v_header_from po_headers_archive%ROWTYPE;
448: v_header_to po_headers_archive%ROWTYPE;
449:
450: v_release_from po_releases_archive%ROWTYPE;
451: v_release_to po_releases_archive%ROWTYPE;
452:
453: v_previous_revision_num NUMBER;
454: v_progress VARCHAR2(3);

Line 451: v_release_to po_releases_archive%ROWTYPE;

447: v_header_from po_headers_archive%ROWTYPE;
448: v_header_to po_headers_archive%ROWTYPE;
449:
450: v_release_from po_releases_archive%ROWTYPE;
451: v_release_to po_releases_archive%ROWTYPE;
452:
453: v_previous_revision_num NUMBER;
454: v_progress VARCHAR2(3);
455:

Line 520: FROM po_releases_archive

516:
517: v_progress := '140';
518: SELECT *
519: INTO v_release_to
520: FROM po_releases_archive
521: WHERE
522: po_release_id = p_release_id
523: AND revision_num = p_revision_num;
524:

Line 536: FROM po_releases_archive

532:
533: v_progress := '150';
534: SELECT *
535: INTO v_release_from
536: FROM po_releases_archive
537: WHERE
538: po_release_id = p_release_id
539: AND revision_num = v_previous_revision_num;
540:

Line 581: * PO_RELEASES_ARCHIVE_ALL table

577: * ARGUMENTS
578: * p_header_id Unique identified for the PO in
579: * PO_HEADERS_ARCHIVE_ALL table
580: * p_release_id Unique identifier for the PO release in
581: * PO_RELEASES_ARCHIVE_ALL table
582: * p_revision_num Current PO revision number
583: * p_comparison_flag Indicator to compare the PO with the previous
584: * or original revision
585: * p_sequence_num Sequence number to identify the comparison

Line 711: * PO_RELEASES_ARCHIVE_ALL table

707: * ARGUMENTS
708: * p_header_id Unique identified for the PO in
709: * PO_HEADERS_ARCHIVE_ALL table
710: * p_release_id Unique identifier for the PO release in
711: * PO_RELEASES_ARCHIVE_ALL table
712: * p_revision_num Current PO revision number
713: * p_comparison_flag Indicator to compare the PO with the previous
714: * or original revision
715: * p_sequence_num Sequence number to identify the comparison

Line 845: * PO_RELEASES_ARCHIVE_ALL table

841: * ARGUMENTS
842: * p_header_id Unique identified for the PO in
843: * PO_HEADERS_ARCHIVE_ALL table
844: * p_release_id Unique identifier for the PO release in
845: * PO_RELEASES_ARCHIVE_ALL table
846: * p_revision_num Current PO revision number
847: * p_comparison_flag Indicator to compare the PO with the previous
848: * or original revision
849: * p_sequence_num Sequence number to identify the comparison

Line 978: * PO_RELEASES_ARCHIVE_ALL table

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
981: * p_dummy_in5 Not required
982: * p_dummy_in6 Not required

Line 1076: * PO_RELEASES_ARCHIVE_ALL table

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
1079: * p_dummy_in5 Not required
1080: * p_dummy_in6 Not required

Line 1174: * PO_RELEASES_ARCHIVE_ALL table

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
1177: * p_dummy_in5 Not required
1178: * p_dummy_in6 Not required

Line 1274: * PO_RELEASES_ARCHIVE_ALL table

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
1277: * or original revision
1278: * p_sequence_num Sequence number to identify the comparison

Line 1496: * in PO_RELEASES_ARCHIVE_ALL table

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
1499: * or original revision
1500: * p_sequence_num Sequence number to identify the comparison

Line 1631: * in PO_RELEASES_ARCHIVE_ALL table

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
1634: * or original revision
1635: * p_sequence_num Sequence number to identify the comparison