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.WMS_ASN_INTERFACE dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 42: FROM wms_license_plate_numbers

38: (p_shipment_header_id NUMBER)
39: IS
40: CURSOR l_lpn_curs IS
41: SELECT lpn_id
42: FROM wms_license_plate_numbers
43: WHERE source_header_id = p_shipment_header_id
44: AND lpn_context = 7
45: AND source_type_id = 1;
46: l_lpn_id NUMBER;

Line 69: DELETE wms_license_plate_numbers

65:
66: DELETE wms_lpn_contents
67: WHERE parent_lpn_id = l_lpn_id;
68:
69: DELETE wms_license_plate_numbers
70: WHERE lpn_id = l_lpn_id;
71:
72: END LOOP;
73:

Line 124: FROM wms_license_plate_numbers wlpn,

120: CURSOR l_print_lpn_curs
121: (v_group_id NUMBER)
122: IS
123: SELECT DISTINCT wlpn.lpn_id
124: FROM wms_license_plate_numbers wlpn,
125: rcv_transactions_interface rti
126: WHERE wlpn.source_header_id = rti.shipment_header_id
127: AND wlpn.lpn_context = 7
128: AND wlpn.source_type_id = 1

Line 457: FROM wms_license_plate_numbers

453:
454: BEGIN
455: SELECT lpn_id
456: INTO l_lpn_id
457: FROM wms_license_plate_numbers
458: WHERE license_plate_number = l_lpn_interface_rec.license_plate_number
459: AND source_header_id = l_shipment_header_id
460: AND lpn_context = 7
461: AND source_type_id = 1;

Line 1023: FROM wms_license_plate_numbers

1019: (p_shipment_header_id IN NUMBER)
1020: IS
1021: CURSOR l_lpn_curs IS
1022: SELECT lpn_id
1023: FROM wms_license_plate_numbers
1024: WHERE source_header_id = p_shipment_header_id
1025: AND lpn_context = 7
1026: AND source_type_id = 1;
1027: