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_ATF_DEST_LOC dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 244: wms_license_plate_numbers wlpn1,

240: from mtl_item_locations milk,
241: mtl_material_transactions_temp mmtt,
242: wms_op_operation_instances wooi,
243: wms_op_plan_instances wopi,
244: wms_license_plate_numbers wlpn1,
245: wms_license_plate_numbers wlpn2
246: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
247: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
248: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 245: wms_license_plate_numbers wlpn2

241: mtl_material_transactions_temp mmtt,
242: wms_op_operation_instances wooi,
243: wms_op_plan_instances wopi,
244: wms_license_plate_numbers wlpn1,
245: wms_license_plate_numbers wlpn2
246: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
247: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
248: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
249: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 269: wms_license_plate_numbers wlpn1,

265: wms_zone_locators wzl,
266: mtl_material_transactions_temp mmtt,
267: wms_op_operation_instances wooi,
268: wms_op_plan_instances wopi,
269: wms_license_plate_numbers wlpn1,
270: wms_license_plate_numbers wlpn2
271: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
272: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
273: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 270: wms_license_plate_numbers wlpn2

266: mtl_material_transactions_temp mmtt,
267: wms_op_operation_instances wooi,
268: wms_op_plan_instances wopi,
269: wms_license_plate_numbers wlpn1,
270: wms_license_plate_numbers wlpn2
271: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
272: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
273: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
274: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 297: wms_license_plate_numbers wlpn1,

293: wms_zone_locators wzl,
294: mtl_material_transactions_temp mmtt,
295: wms_op_operation_instances wooi,
296: wms_op_plan_instances wopi,
297: wms_license_plate_numbers wlpn1,
298: wms_license_plate_numbers wlpn2
299: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
300: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
301: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 298: wms_license_plate_numbers wlpn2

294: mtl_material_transactions_temp mmtt,
295: wms_op_operation_instances wooi,
296: wms_op_plan_instances wopi,
297: wms_license_plate_numbers wlpn1,
298: wms_license_plate_numbers wlpn2
299: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
300: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
301: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
302: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 326: wms_license_plate_numbers wlpn1,

322: from mtl_item_locations milk,
323: mtl_material_transactions_temp mmtt,
324: wms_op_operation_instances wooi,
325: wms_op_plan_instances wopi,
326: wms_license_plate_numbers wlpn1,
327: wms_license_plate_numbers wlpn2
328: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
329: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
330: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 327: wms_license_plate_numbers wlpn2

323: mtl_material_transactions_temp mmtt,
324: wms_op_operation_instances wooi,
325: wms_op_plan_instances wopi,
326: wms_license_plate_numbers wlpn1,
327: wms_license_plate_numbers wlpn2
328: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
329: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
330: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
331: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 352: wms_license_plate_numbers wlpn1,

348: wms_zone_locators wzl,
349: mtl_material_transactions_temp mmtt,
350: wms_op_operation_instances wooi,
351: wms_op_plan_instances wopi,
352: wms_license_plate_numbers wlpn1,
353: wms_license_plate_numbers wlpn2
354: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
355: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
356: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 353: wms_license_plate_numbers wlpn2

349: mtl_material_transactions_temp mmtt,
350: wms_op_operation_instances wooi,
351: wms_op_plan_instances wopi,
352: wms_license_plate_numbers wlpn1,
353: wms_license_plate_numbers wlpn2
354: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
355: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
356: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
357: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 381: wms_license_plate_numbers wlpn1,

377: wms_zone_locators wzl,
378: mtl_material_transactions_temp mmtt,
379: wms_op_operation_instances wooi,
380: wms_op_plan_instances wopi,
381: wms_license_plate_numbers wlpn1,
382: wms_license_plate_numbers wlpn2
383: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
384: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
385: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)

Line 382: wms_license_plate_numbers wlpn2

378: mtl_material_transactions_temp mmtt,
379: wms_op_operation_instances wooi,
380: wms_op_plan_instances wopi,
381: wms_license_plate_numbers wlpn1,
382: wms_license_plate_numbers wlpn2
383: where wopi.plan_type_id = decode(l_loc_mtrl_grp_rule_id,1,l_plan_type_id,wopi.plan_type_id)
384: and wopi.orig_dest_sub_code = decode(l_loc_mtrl_grp_rule_id,2,l_orig_dest_sub_code,wopi.orig_dest_sub_code )
385: and wopi.orig_dest_loc_id = decode(l_loc_mtrl_grp_rule_id,3,l_orig_dest_loc_id,wopi.orig_dest_loc_id)
386: and wooi.op_plan_instance_id = wopi.op_plan_instance_id

Line 465: wms_license_plate_numbers wlpn,

461: from wms_op_plan_instances_hist wopih,
462: wms_op_opertn_instances_hist wooih,
463: mtl_secondary_inventories msi,
464: wms_zone_locators wzl,
465: wms_license_plate_numbers wlpn,
466: wms_dispatched_tasks_history wdth,
467: mtl_item_locations milk1,
468: mtl_item_locations milk2
469: where milk2.subinventory_code = msi.secondary_inventory_name

Line 526: wms_license_plate_numbers wlpn,

522: from wms_op_plan_instances_hist wopih,
523: wms_op_opertn_instances_hist wooih,
524: mtl_secondary_inventories msi,
525: wms_zone_locators wzl,
526: wms_license_plate_numbers wlpn,
527: wms_dispatched_tasks_history wdth,
528: mtl_item_locations milk1,
529: mtl_item_locations milk2
530: where milk2.subinventory_code = msi.secondary_inventory_name

Line 639: wms_license_plate_numbers wlpn,

635: wms_op_opertn_instances_hist wooih,
636: mtl_secondary_inventories msi,
637: wms_zone_locators wzl,
638: wms_dispatched_tasks_history wdth,
639: wms_license_plate_numbers wlpn,
640: mtl_item_locations milk1,
641: mtl_item_locations milk2
642: where milk2.subinventory_code = msi.secondary_inventory_name
643: and milk2.organization_id = msi.organization_id

Line 697: wms_license_plate_numbers wlpn,

693: wms_op_opertn_instances_hist wooih,
694: mtl_secondary_inventories msi,
695: wms_zone_locators wzl,
696: wms_dispatched_tasks_history wdth,
697: wms_license_plate_numbers wlpn,
698: mtl_item_locations milk1,
699: mtl_item_locations milk2
700: where milk2.subinventory_code = msi.secondary_inventory_name
701: and milk2.organization_id = msi.organization_id

Line 809: wms_license_plate_numbers wlpn,

805: mtl_item_locations milk2,
806: mtl_secondary_inventories msi,
807: wms_zone_locators wzl,
808: -- ***** tables from the inner cursor *****
809: wms_license_plate_numbers wlpn,
810: wms_dispatched_tasks_history wdth,
811: wms_op_opertn_instances_hist wooih,
812: wms_op_plan_instances_hist wopih
813: where milk2.subinventory_code = msi.secondary_inventory_name

Line 871: wms_license_plate_numbers wlpn,

867: mtl_item_locations milk2,
868: mtl_secondary_inventories msi,
869: wms_zone_locators wzl,
870: -- ***** tables from the inner cursor *****
871: wms_license_plate_numbers wlpn,
872: wms_dispatched_tasks_history wdth,
873: wms_op_opertn_instances_hist wooih,
874: wms_op_plan_instances_hist wopih
875: where milk2.subinventory_code = msi.secondary_inventory_name

Line 984: wms_license_plate_numbers wlpn,

980: wms_op_opertn_instances_hist wooih,
981: mtl_secondary_inventories msi,
982: wms_zone_locators wzl,
983: wms_dispatched_tasks_history wdth,
984: wms_license_plate_numbers wlpn,
985: mtl_item_locations milk1,
986: mtl_item_locations milk2
987: where milk2.subinventory_code = msi.secondary_inventory_name
988: and milk2.organization_id = msi.organization_id

Line 1040: wms_license_plate_numbers wlpn,

1036: wms_op_opertn_instances_hist wooih,
1037: mtl_secondary_inventories msi,
1038: wms_zone_locators wzl,
1039: wms_dispatched_tasks_history wdth,
1040: wms_license_plate_numbers wlpn,
1041: mtl_item_locations milk1,
1042: mtl_item_locations milk2
1043: where milk2.subinventory_code = msi.secondary_inventory_name
1044: and milk2.organization_id = msi.organization_id

Line 1149: wms_license_plate_numbers wlpn,

1145: from wms_op_plan_instances_hist wopih,
1146: wms_op_opertn_instances_hist wooih,
1147: mtl_secondary_inventories msi,
1148: wms_dispatched_tasks_history wdth,
1149: wms_license_plate_numbers wlpn,
1150: mtl_item_locations milk1,
1151: mtl_item_locations milk2
1152: where milk2.subinventory_code = msi.secondary_inventory_name
1153: and milk2.organization_id = msi.organization_id

Line 1206: wms_license_plate_numbers wlpn,

1202: from wms_op_plan_instances_hist wopih,
1203: wms_op_opertn_instances_hist wooih,
1204: mtl_secondary_inventories msi,
1205: wms_dispatched_tasks_history wdth,
1206: wms_license_plate_numbers wlpn,
1207: mtl_item_locations milk1,
1208: mtl_item_locations milk2
1209: where milk2.subinventory_code = msi.secondary_inventory_name
1210: and milk2.organization_id = msi.organization_id

Line 1309: wms_license_plate_numbers wlpn,

1305: from wms_op_plan_instances_hist wopih,
1306: wms_op_opertn_instances_hist wooih,
1307: mtl_secondary_inventories msi,
1308: wms_dispatched_tasks_history wdth,
1309: wms_license_plate_numbers wlpn,
1310: mtl_item_locations milk1,
1311: mtl_item_locations milk2
1312: where milk2.subinventory_code = msi.secondary_inventory_name
1313: and milk2.organization_id = msi.organization_id

Line 1359: wms_license_plate_numbers wlpn,

1355: from wms_op_plan_instances_hist wopih,
1356: wms_op_opertn_instances_hist wooih,
1357: mtl_secondary_inventories msi,
1358: wms_dispatched_tasks_history wdth,
1359: wms_license_plate_numbers wlpn,
1360: mtl_item_locations milk1,
1361: mtl_item_locations milk2
1362: where milk2.subinventory_code = msi.secondary_inventory_name
1363: and milk2.organization_id = msi.organization_id