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_SHIPPING_TRANSACTION_PUB dependencies on MTL_ITEM_LOCATIONS_KFV

Line 169: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

165: --Bug#6018835.Added following cursor.
166: --cursor to check if any apptmts within the current time window.
167: CURSOR current_schedule_cur IS
168: SELECT 1
169: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
170: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
171: WHERE wda.dock_id = milk.inventory_location_id (+)
172: and wda.organization_id = milk.organization_id (+)
173: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 170: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

166: --cursor to check if any apptmts within the current time window.
167: CURSOR current_schedule_cur IS
168: SELECT 1
169: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
170: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
171: WHERE wda.dock_id = milk.inventory_location_id (+)
172: and wda.organization_id = milk.organization_id (+)
173: and wda.trip_stop = wdl.pick_up_stop_id (+)
174: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 190: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

186: --Bug#6018835.Added following cursor.
187: --cursor to check if any apptmts missed to be used in the past.
188: CURSOR last_recent_schedule_cur IS
189: SELECT 1
190: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
191: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
192: WHERE wda.dock_id = milk.inventory_location_id (+)
193: and wda.organization_id = milk.organization_id (+)
194: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 191: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

187: --cursor to check if any apptmts missed to be used in the past.
188: CURSOR last_recent_schedule_cur IS
189: SELECT 1
190: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
191: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
192: WHERE wda.dock_id = milk.inventory_location_id (+)
193: and wda.organization_id = milk.organization_id (+)
194: and wda.trip_stop = wdl.pick_up_stop_id (+)
195: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 237: , mtl_item_locations_kfv milk

233: , milk1.concatenated_segments
234: , is_loaded(p_organization_id,wda.dock_id,'Y')
235: , wt.name trip_name
236: from wms_dock_appointments_b wda
237: , mtl_item_locations_kfv milk
238: , wsh_delivery_legs_ob_grp_v wdl
239: , wsh_Trip_stops_ob_grp_v wts
240: , mtl_item_locations_kfv milk1
241: ,wsh_trips wt

Line 240: , mtl_item_locations_kfv milk1

236: from wms_dock_appointments_b wda
237: , mtl_item_locations_kfv milk
238: , wsh_delivery_legs_ob_grp_v wdl
239: , wsh_Trip_stops_ob_grp_v wts
240: , mtl_item_locations_kfv milk1
241: ,wsh_trips wt
242: where wda.dock_id = milk.inventory_location_id (+)
243: and wda.organization_id = milk.organization_id (+)
244: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 275: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,

271: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
272: milk1.subinventory_code, milk1.concatenated_segments ,
273: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
274: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
275: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
276: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
277: WHERE wda.dock_id = milk.inventory_location_id (+)
278: and wda.organization_id = milk.organization_id (+)
279: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 276: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

272: milk1.subinventory_code, milk1.concatenated_segments ,
273: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
274: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
275: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
276: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
277: WHERE wda.dock_id = milk.inventory_location_id (+)
278: and wda.organization_id = milk.organization_id (+)
279: and wda.trip_stop = wdl.pick_up_stop_id (+)
280: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 304: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,

300: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
301: milk1.subinventory_code, milk1.concatenated_segments ,
302: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
303: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
304: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
305: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
306: WHERE wda.dock_id = milk.inventory_location_id (+)
307: and wda.organization_id = milk.organization_id (+)
308: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 305: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

301: milk1.subinventory_code, milk1.concatenated_segments ,
302: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
303: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
304: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
305: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
306: WHERE wda.dock_id = milk.inventory_location_id (+)
307: and wda.organization_id = milk.organization_id (+)
308: and wda.trip_stop = wdl.pick_up_stop_id (+)
309: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 336: from mtl_item_locations_kfv milk

332: milk_concatenated_segments
333: ,0, milk.organization_id,
334: 0,0,'','',is_loaded(p_organization_id,milk.inventory_location_id,'N')
335: ,''
336: from mtl_item_locations_kfv milk
337: where inventory_location_type = 1
338: AND milk.organization_id = p_organization_id
339: AND inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) like (p_dock_door)
340: --AND segment19 IS NULL -- Bug 5336849, As a release policy

Line 586: , mtl_item_locations_kfv milk

582: if( p_txn_dock = 'Y' ) then
583: open x_staging_lane_lov for
584: select distinct wda.staging_lane_id, milk.concatenated_segments
585: from wms_dock_appointments_b wda
586: , mtl_item_locations_kfv milk
587: , wsh_trip_Stops_ob_grp_v pickup_stop
588: where milk.inventory_location_id(+) = wda.staging_lane_id
589: and milk.organization_id(+) = wda.organization_id
590: and milk.organization_id = p_organization_id

Line 598: from mtl_item_locations_kfv milk

594: and milk.concatenated_segments like (p_staging_lane);
595: elsif( p_txn_dock = 'N' ) then
596: open x_staging_lane_lov for
597: select distinct milk.inventory_location_id, milk.concatenated_segments
598: from mtl_item_locations_kfv milk
599: , wms_license_plate_numbers lpn
600: where milk.inventory_location_id (+) = lpn.locator_id
601: and milk.organization_id (+) = lpn.organization_id
602: and milk.organization_id = p_organization_id

Line 1560: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1556: and wdd.delivery_detail_id = wda.delivery_detail_id;
1557:
1558: cursor lpn_in_other_dock(p_delivery_id NUMBER) is
1559: select distinct milk.concatenated_segments
1560: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1561: where wstt.delivery_id = p_delivery_id
1562: and wstt.organization_id = p_organization_id
1563: and wstt.dock_appoint_flag = 'N'
1564: and wstt.dock_door_id <> p_dock_door_id

Line 1570: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1566: and milk.inventory_location_id =wstt.dock_door_id;
1567:
1568: cursor lpn_in_other_dock2(p_trip_id NUMBER) is
1569: select distinct milk.concatenated_segments
1570: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1571: where wstt.trip_id = p_trip_id
1572: and wstt.organization_id = p_organization_id
1573: and wstt.dock_appoint_flag = 'N'
1574: and wstt.dock_door_id <> p_dock_door_id

Line 1593: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt

1589: BEGIN
1590: select wt.name, milk.concatenated_segments
1591: into x_trip_name, x_loaded_dock_door
1592: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1593: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1594: where wdl.delivery_id = l_delivery_id
1595: and wdl.pick_up_stop_id = wts.stop_id
1596: and wda.trip_stop = wts.stop_id
1597: and wda.organization_id = p_organization_id

Line 3026: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,

3022: select DISTINCT wlpn.license_plate_number,
3023: lpn.subinventory_code,
3024: milk.concatenated_segments,
3025: wnd.name
3026: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
3027: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
3028: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
3029: where wdd.delivery_detail_id = wda.delivery_detail_id
3030: and wdd.released_status = 'Y'

Line 3049: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,

3045: select DISTINCT wlpn.license_plate_number,
3046: lpn.subinventory_code,
3047: milk.concatenated_segments,
3048: wnd.name
3049: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
3050: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
3051: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
3052: where wdd.delivery_detail_id = wda.delivery_detail_id
3053: and wdd.released_status = 'Y'

Line 3148: , mtl_item_locations_kfv milk

3144: , lpn.locator_id
3145: , milk.concatenated_segments
3146: , wnd.name
3147: from wms_license_plate_numbers lpn
3148: , mtl_item_locations_kfv milk
3149: , wsh_trip_stops_ob_grp_v pickup_stop
3150: , wsh_delivery_legs_ob_grp_v wdl
3151: , wsh_delivery_assignments_v wda
3152: , wsh_delivery_details_ob_grp_v wdd

Line 3232: , mtl_item_locations_kfv milk

3228: , lpn.locator_id
3229: , milk.concatenated_segments
3230: , wnd.name
3231: from wms_license_plate_numbers lpn
3232: , mtl_item_locations_kfv milk
3233: , wsh_delivery_assignments_v wda
3234: , wsh_delivery_details_ob_grp_v wdd
3235: , wsh_delivery_details_ob_grp_v wdd2
3236: , wsh_new_deliveries_ob_grp_v wnd

Line 5563: mtl_item_locations_kfv milk

5559: select distinct wlpn.license_plate_number, wlpn.lpn_id,
5560: wlpn.subinventory_code, milk.concatenated_segments
5561: from wms_license_plate_numbers wlpn,
5562: wms_shipping_transaction_temp wstt,
5563: mtl_item_locations_kfv milk
5564: WHERE wlpn.organization_id = wstt.organization_id
5565: AND wlpn.organization_id = p_organization_id
5566: AND wlpn.lpn_id = wstt.outermost_lpn_id
5567: and wlpn.lpn_context = wms_globals.lpn_loaded_for_shipment

Line 5602: mtl_item_locations_kfv milk

5598: '' staging_lane,
5599: '' loaded, --is_loaded(wstt.organization_id,wstt.dock_door_id,'N') loaded,
5600: '' trip_name
5601: FROM wms_shipping_transaction_temp wstt,
5602: mtl_item_locations_kfv milk
5603: WHERE wstt.organization_id = p_organization_id
5604: AND milk.inventory_location_type = 1
5605: AND milk.organization_id = wstt.organization_id
5606: AND milk.inventory_location_id = wstt.dock_door_id

Line 6580: , mtl_item_locations_kfv milk

6576: , wlpn.subinventory_code
6577: , milk.concatenated_segments
6578: from wms_license_plate_numbers wlpn
6579: , wms_shipping_transaction_temp wstt
6580: , mtl_item_locations_kfv milk
6581: WHERE wlpn.organization_id = wstt.organization_id
6582: AND wlpn.organization_id = p_organization_id
6583: AND wlpn.lpn_id = wstt.outermost_lpn_id
6584: AND nvl(wstt.direct_ship_flag,'N') = 'Y'