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 118: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

114: --Bug#6018835.Added following cursor.
115: --cursor to check if any apptmts within the current time window.
116: CURSOR current_schedule_cur IS
117: SELECT 1
118: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
119: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
120: WHERE wda.dock_id = milk.inventory_location_id (+)
121: and wda.organization_id = milk.organization_id (+)
122: and wda.trip_stop = wdl.pick_up_stop_id (+)

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

115: --cursor to check if any apptmts within the current time window.
116: CURSOR current_schedule_cur IS
117: SELECT 1
118: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
119: wsh_delivery_legs_ob_grp_v wdl, wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
120: WHERE wda.dock_id = milk.inventory_location_id (+)
121: and wda.organization_id = milk.organization_id (+)
122: and wda.trip_stop = wdl.pick_up_stop_id (+)
123: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 139: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,

135: --Bug#6018835.Added following cursor.
136: --cursor to check if any apptmts missed to be used in the past.
137: CURSOR last_recent_schedule_cur IS
138: SELECT 1
139: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
140: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
141: WHERE wda.dock_id = milk.inventory_location_id (+)
142: and wda.organization_id = milk.organization_id (+)
143: and wda.trip_stop = wdl.pick_up_stop_id (+)

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

136: --cursor to check if any apptmts missed to be used in the past.
137: CURSOR last_recent_schedule_cur IS
138: SELECT 1
139: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk,
140: wsh_delivery_legs_ob_grp_v wdl,wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
141: WHERE wda.dock_id = milk.inventory_location_id (+)
142: and wda.organization_id = milk.organization_id (+)
143: and wda.trip_stop = wdl.pick_up_stop_id (+)
144: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 186: , mtl_item_locations_kfv milk

182: , milk1.concatenated_segments
183: , is_loaded(p_organization_id,wda.dock_id,'Y')
184: , wt.name trip_name
185: from wms_dock_appointments_b wda
186: , mtl_item_locations_kfv milk
187: , wsh_delivery_legs_ob_grp_v wdl
188: , wsh_Trip_stops_ob_grp_v wts
189: , mtl_item_locations_kfv milk1
190: ,wsh_trips wt

Line 189: , mtl_item_locations_kfv milk1

185: from wms_dock_appointments_b wda
186: , mtl_item_locations_kfv milk
187: , wsh_delivery_legs_ob_grp_v wdl
188: , wsh_Trip_stops_ob_grp_v wts
189: , mtl_item_locations_kfv milk1
190: ,wsh_trips wt
191: where wda.dock_id = milk.inventory_location_id (+)
192: and wda.organization_id = milk.organization_id (+)
193: and wda.trip_stop = wdl.pick_up_stop_id (+)

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

220: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
221: milk1.subinventory_code, milk1.concatenated_segments ,
222: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
223: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
224: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
226: WHERE wda.dock_id = milk.inventory_location_id (+)
227: and wda.organization_id = milk.organization_id (+)
228: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

221: milk1.subinventory_code, milk1.concatenated_segments ,
222: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
223: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
224: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
226: WHERE wda.dock_id = milk.inventory_location_id (+)
227: and wda.organization_id = milk.organization_id (+)
228: and wda.trip_stop = wdl.pick_up_stop_id (+)
229: and wdl.pick_up_stop_id = wts.stop_id (+)

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

249: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
250: milk1.subinventory_code, milk1.concatenated_segments ,
251: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
252: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
253: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
255: WHERE wda.dock_id = milk.inventory_location_id (+)
256: and wda.organization_id = milk.organization_id (+)
257: and wda.trip_stop = wdl.pick_up_stop_id (+)

Line 254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt

250: milk1.subinventory_code, milk1.concatenated_segments ,
251: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
252: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
253: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
255: WHERE wda.dock_id = milk.inventory_location_id (+)
256: and wda.organization_id = milk.organization_id (+)
257: and wda.trip_stop = wdl.pick_up_stop_id (+)
258: and wdl.pick_up_stop_id = wts.stop_id (+)

Line 285: from mtl_item_locations_kfv milk

281: milk_concatenated_segments
282: ,0, milk.organization_id,
283: 0,0,'','',is_loaded(p_organization_id,milk.inventory_location_id,'N')
284: ,''
285: from mtl_item_locations_kfv milk
286: where inventory_location_type = 1
287: AND milk.organization_id = p_organization_id
288: AND inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) like (p_dock_door)
289: --AND segment19 IS NULL -- Bug 5336849, As a release policy

Line 533: , mtl_item_locations_kfv milk

529: if( p_txn_dock = 'Y' ) then
530: open x_staging_lane_lov for
531: select distinct wda.staging_lane_id, milk.concatenated_segments
532: from wms_dock_appointments_b wda
533: , mtl_item_locations_kfv milk
534: , wsh_trip_Stops_ob_grp_v pickup_stop
535: where milk.inventory_location_id(+) = wda.staging_lane_id
536: and milk.organization_id(+) = wda.organization_id
537: and milk.organization_id = p_organization_id

Line 545: from mtl_item_locations_kfv milk

541: and milk.concatenated_segments like (p_staging_lane);
542: elsif( p_txn_dock = 'N' ) then
543: open x_staging_lane_lov for
544: select distinct milk.inventory_location_id, milk.concatenated_segments
545: from mtl_item_locations_kfv milk
546: , wms_license_plate_numbers lpn
547: where milk.inventory_location_id (+) = lpn.locator_id
548: and milk.organization_id (+) = lpn.organization_id
549: and milk.organization_id = p_organization_id

Line 1502: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1498: and wdd.delivery_detail_id = wda.delivery_detail_id;
1499:
1500: cursor lpn_in_other_dock(p_delivery_id NUMBER) is
1501: select distinct milk.concatenated_segments
1502: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1503: where wstt.delivery_id = p_delivery_id
1504: and wstt.organization_id = p_organization_id
1505: and wstt.dock_appoint_flag = 'N'
1506: and wstt.dock_door_id <> p_dock_door_id

Line 1512: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt

1508: and milk.inventory_location_id =wstt.dock_door_id;
1509:
1510: cursor lpn_in_other_dock2(p_trip_id NUMBER) is
1511: select distinct milk.concatenated_segments
1512: from mtl_item_locations_kfv milk,wms_shipping_transaction_temp wstt
1513: where wstt.trip_id = p_trip_id
1514: and wstt.organization_id = p_organization_id
1515: and wstt.dock_appoint_flag = 'N'
1516: and wstt.dock_door_id <> p_dock_door_id

Line 1535: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt

1531: BEGIN
1532: select wt.name, milk.concatenated_segments
1533: into x_trip_name, x_loaded_dock_door
1534: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1535: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1536: where wdl.delivery_id = l_delivery_id
1537: and wdl.pick_up_stop_id = wts.stop_id
1538: and wda.trip_stop = wts.stop_id
1539: and wda.organization_id = p_organization_id

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

2961: select DISTINCT wlpn.license_plate_number,
2962: lpn.subinventory_code,
2963: milk.concatenated_segments,
2964: wnd.name
2965: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,wsh_trip_stops_ob_grp_v pickup_stop,
2966: wsh_delivery_legs_ob_grp_v wdl,wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2967: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2968: where wdd.delivery_detail_id = wda.delivery_detail_id
2969: and wdd.released_status = 'Y'

Line 2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,

2984: select DISTINCT wlpn.license_plate_number,
2985: lpn.subinventory_code,
2986: milk.concatenated_segments,
2987: wnd.name
2988: from wms_license_plate_numbers lpn, mtl_item_locations_kfv milk,
2989: wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd,
2990: wsh_delivery_details_ob_grp_v wdd2,wsh_new_deliveries_ob_grp_v wnd,wms_license_plate_numbers wlpn
2991: where wdd.delivery_detail_id = wda.delivery_detail_id
2992: and wdd.released_status = 'Y'

Line 3087: , mtl_item_locations_kfv milk

3083: , lpn.locator_id
3084: , milk.concatenated_segments
3085: , wnd.name
3086: from wms_license_plate_numbers lpn
3087: , mtl_item_locations_kfv milk
3088: , wsh_trip_stops_ob_grp_v pickup_stop
3089: , wsh_delivery_legs_ob_grp_v wdl
3090: , wsh_delivery_assignments_v wda
3091: , wsh_delivery_details_ob_grp_v wdd

Line 3171: , mtl_item_locations_kfv milk

3167: , lpn.locator_id
3168: , milk.concatenated_segments
3169: , wnd.name
3170: from wms_license_plate_numbers lpn
3171: , mtl_item_locations_kfv milk
3172: , wsh_delivery_assignments_v wda
3173: , wsh_delivery_details_ob_grp_v wdd
3174: , wsh_delivery_details_ob_grp_v wdd2
3175: , wsh_new_deliveries_ob_grp_v wnd

Line 5403: mtl_item_locations_kfv milk

5399: select distinct wlpn.license_plate_number, wlpn.lpn_id,
5400: wlpn.subinventory_code, milk.concatenated_segments
5401: from wms_license_plate_numbers wlpn,
5402: wms_shipping_transaction_temp wstt,
5403: mtl_item_locations_kfv milk
5404: WHERE wlpn.organization_id = wstt.organization_id
5405: AND wlpn.organization_id = p_organization_id
5406: AND wlpn.lpn_id = wstt.outermost_lpn_id
5407: and wlpn.lpn_context = wms_globals.lpn_loaded_for_shipment

Line 5430: from mtl_item_locations_kfv milk

5426: milk_concatenated_segments,
5427: 0, milk.organization_id,
5428: 0,0,'','',is_loaded(p_organization_id,milk.inventory_location_id,'N')
5429: ,''
5430: from mtl_item_locations_kfv milk
5431: , wms_shipping_transaction_temp wstt
5432: where inventory_location_type = 1
5433: and milk.organization_id = p_organization_id
5434: AND milk.organization_id = wstt.organization_id

Line 6333: , mtl_item_locations_kfv milk

6329: , wlpn.subinventory_code
6330: , milk.concatenated_segments
6331: from wms_license_plate_numbers wlpn
6332: , wms_shipping_transaction_temp wstt
6333: , mtl_item_locations_kfv milk
6334: WHERE wlpn.organization_id = wstt.organization_id
6335: AND wlpn.organization_id = p_organization_id
6336: AND wlpn.lpn_id = wstt.outermost_lpn_id
6337: AND nvl(wstt.direct_ship_flag,'N') = 'Y'