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_XML_DELIVERY dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 1009: from po_line_locations_archive_all

1005: and po_line_id = p_line_id
1006: and revision_num <= p_revision_num;
1007:
1008: select max(revision_num) into l_max_location_revision
1009: from po_line_locations_archive_all
1010: where po_header_id = p_header_id
1011: and po_line_id = p_line_id
1012: and revision_num <= p_revision_num;
1013:

Line 1058: from po_line_locations_archive_all

1054: where po_header_id= p_header_id;
1055:
1056: if doc_type = 'BLANKET' then
1057: select max(revision_num) into l_one
1058: from po_line_locations_archive_all
1059: where po_header_id = p_header_id
1060: and po_line_id = p_line_id
1061: and line_location_id = p_location_id;
1062:

Line 1065: from po_line_locations_archive_all

1061: and line_location_id = p_location_id;
1062:
1063: else
1064: select max(revision_num) into l_one
1065: from po_line_locations_archive_all
1066: where po_header_id = p_header_id
1067: and po_line_id = p_line_id
1068: and line_location_id = p_location_id
1069: and revision_num <= p_revision_num;

Line 1076: from po_line_locations_archive_all

1072:
1073: if (l_one = p_location_revision_num ) then
1074:
1075: select max(revision_num) into l_max_loc_revision
1076: from po_line_locations_archive_all
1077: where po_header_id = p_header_id
1078: and po_line_id = p_line_id
1079: and line_location_id = p_location_id
1080: and revision_num <= p_revision_num;