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 WMS_CONTAINER_PVT

Line 987: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked

983: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
984: and wdd2.lpn_id is not null -- for performance, bug 2418639
985: and wdd2.lpn_id = lpn.lpn_id
986: and lpn.outermost_lpn_id = wlpn.lpn_id
987: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
988: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
989: and wnd.status_code in ('OP', 'PA')
990: and wdd.released_status = 'Y'
991: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )

Line 988: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

984: and wdd2.lpn_id is not null -- for performance, bug 2418639
985: and wdd2.lpn_id = lpn.lpn_id
986: and lpn.outermost_lpn_id = wlpn.lpn_id
987: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
988: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
989: and wnd.status_code in ('OP', 'PA')
990: and wdd.released_status = 'Y'
991: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
992: and wlpn.license_plate_number like (p_lpn)

Line 1012: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1008: and wdd.lpn_id is not null
1009: and wdd.lpn_id = lpn.outermost_lpn_id
1010: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1011: and lpn.outermost_lpn_id = wlpn.lpn_id
1012: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1013: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1014: and lpn.organization_id = p_organization_id
1015: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1016: and wlpn.license_plate_number like (p_lpn)

Line 1013: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1009: and wdd.lpn_id = lpn.outermost_lpn_id
1010: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1011: and lpn.outermost_lpn_id = wlpn.lpn_id
1012: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1013: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1014: and lpn.organization_id = p_organization_id
1015: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1016: and wlpn.license_plate_number like (p_lpn)
1017: and wda.delivery_id IS NOT NULL

Line 1036: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1032: and wdd.lpn_id is not null
1033: and wdd.lpn_id = lpn.outermost_lpn_id
1034: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1035: and lpn.outermost_lpn_id = wlpn.lpn_id
1036: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1037: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1038: and lpn.organization_id = p_organization_id
1039: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1040: and wlpn.license_plate_number like (p_lpn)

Line 1037: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1033: and wdd.lpn_id = lpn.outermost_lpn_id
1034: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1035: and lpn.outermost_lpn_id = wlpn.lpn_id
1036: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1037: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1038: and lpn.organization_id = p_organization_id
1039: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1040: and wlpn.license_plate_number like (p_lpn)
1041: and wda.delivery_id IS NULL

Line 1059: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1055: and wdd.lpn_id is not null
1056: and wdd.lpn_id = lpn.lpn_id
1057: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1058: and lpn.outermost_lpn_id = wlpn.lpn_id
1059: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1060: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1061: and lpn.organization_id = p_organization_id
1062: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1063: and wlpn.license_plate_number like (p_lpn)

Line 1060: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1056: and wdd.lpn_id = lpn.lpn_id
1057: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1058: and lpn.outermost_lpn_id = wlpn.lpn_id
1059: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1060: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1061: and lpn.organization_id = p_organization_id
1062: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1063: and wlpn.license_plate_number like (p_lpn)
1064: and wda.delivery_id IS NOT NULL

Line 1083: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1079: and wdd.lpn_id is not null
1080: and wdd.lpn_id = lpn.lpn_id
1081: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1082: and lpn.outermost_lpn_id = wlpn.lpn_id
1083: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1084: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1085: and lpn.organization_id = p_organization_id
1086: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1087: and wlpn.license_plate_number like (p_lpn)

Line 1084: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1080: and wdd.lpn_id = lpn.lpn_id
1081: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1082: and lpn.outermost_lpn_id = wlpn.lpn_id
1083: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1084: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1085: and lpn.organization_id = p_organization_id
1086: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1087: and wlpn.license_plate_number like (p_lpn)
1088: and wda.delivery_id IS NULL

Line 1118: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1114: and wdd2.lpn_id is not null -- for performance, bug 2418639
1115: and wdd2.lpn_id = lpn.lpn_id
1116: and lpn.outermost_lpn_id = wlpn.lpn_id
1117: --MR-MDC wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
1118: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1119: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1120: -- 5582189 dherring additional criteria added to ensure ship confirmed deliveries
1121: -- do not appear in the lov
1122: and wnd.status_code in ('OP', 'PA')

Line 1119: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1115: and wdd2.lpn_id = lpn.lpn_id
1116: and lpn.outermost_lpn_id = wlpn.lpn_id
1117: --MR-MDC wlpn.lpn_context <> wms_globals.lpn_loaded_for_shipment
1118: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1119: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1120: -- 5582189 dherring additional criteria added to ensure ship confirmed deliveries
1121: -- do not appear in the lov
1122: and wnd.status_code in ('OP', 'PA')
1123: and wdd.released_status = 'Y'

Line 1144: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1140: and wdd.lpn_id is not null -- for performance, bug 2418639
1141: and wdd.lpn_id = lpn.outermost_lpn_id
1142: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1143: and lpn.outermost_lpn_id = wlpn.lpn_id
1144: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1145: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1146: and lpn.organization_id = p_organization_id
1147: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1148: and wlpn.license_plate_number like (p_lpn)

Line 1145: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1141: and wdd.lpn_id = lpn.outermost_lpn_id
1142: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1143: and lpn.outermost_lpn_id = wlpn.lpn_id
1144: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1145: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1146: and lpn.organization_id = p_organization_id
1147: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1148: and wlpn.license_plate_number like (p_lpn)
1149: -- 5582189 dherring UNION introduced to avoid cartesian join

Line 1168: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked

1164: and wdd.lpn_id is not null -- for performance, bug 2418639
1165: and wdd.lpn_id = lpn.outermost_lpn_id
1166: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1167: and lpn.outermost_lpn_id = wlpn.lpn_id
1168: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1169: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1170: and lpn.organization_id = p_organization_id
1171: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1172: and wlpn.license_plate_number like (p_lpn)

Line 1169: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

1165: and wdd.lpn_id = lpn.outermost_lpn_id
1166: and wdd.released_status = 'X' -- For LPN reuse ER : 6845650
1167: and lpn.outermost_lpn_id = wlpn.lpn_id
1168: and (wlpn.lpn_context = wms_container_pvt.lpn_context_picked
1169: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
1170: and lpn.organization_id = p_organization_id
1171: and (wdd.inv_interfaced_flag <> 'Y' or wdd.inv_interfaced_flag is null )
1172: and wlpn.license_plate_number like (p_lpn)
1173: -- 5582189 dherring UNION introduced to avoid cartesian join

Line 3126: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked

3122: and wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3123: and wdd2.lpn_id = lpn.lpn_id
3124: and lpn.outermost_lpn_id = wlpn.lpn_id
3125: AND wdd.organization_id = p_organization_id
3126: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3127: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3128: -- 5582189 dherring changed code to select picked lpns
3129: and wnd.status_code in ('OP', 'PA');
3130: --and wlpn.lpn_context <> 9;

Line 3127: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

3123: and wdd2.lpn_id = lpn.lpn_id
3124: and lpn.outermost_lpn_id = wlpn.lpn_id
3125: AND wdd.organization_id = p_organization_id
3126: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3127: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3128: -- 5582189 dherring changed code to select picked lpns
3129: and wnd.status_code in ('OP', 'PA');
3130: --and wlpn.lpn_context <> 9;
3131: if l_count > 0 then

Line 3165: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked

3161: and wdl.pick_up_stop_id = pickup_stop.stop_id
3162: and pickup_stop.trip_id = p_trip_id
3163: and lpn.lpn_id = wdd2.lpn_id
3164: and lpn.outermost_lpn_id = wlpn.lpn_id
3165: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3166: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3167: --and wlpn.lpn_context <> 9
3168: -- 5582189 dherring changed code to select picked lpns
3169: and wnd.status_code in ('OP', 'PA')

Line 3166: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

3162: and pickup_stop.trip_id = p_trip_id
3163: and lpn.lpn_id = wdd2.lpn_id
3164: and lpn.outermost_lpn_id = wlpn.lpn_id
3165: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3166: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3167: --and wlpn.lpn_context <> 9
3168: -- 5582189 dherring changed code to select picked lpns
3169: and wnd.status_code in ('OP', 'PA')
3170: and lpn.locator_id = milk.inventory_location_id

Line 3207: wms_container_pvt.lpn_context_picked

3203: and wdd2.lpn_id = lpn.lpn_id
3204: and wlpn.lpn_id = lpn.outermost_lpn_id
3205: AND wdd.organization_id = p_organization_id
3206: and ( wlpn.lpn_context =
3207: wms_container_pvt.lpn_context_picked
3208: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3209: -- 5582189 dherring changed code to select picked lpns
3210: and wda.delivery_id = wnd.delivery_id
3211: and wnd.status_code in ('OP', 'PA');

Line 3208: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

3204: and wlpn.lpn_id = lpn.outermost_lpn_id
3205: AND wdd.organization_id = p_organization_id
3206: and ( wlpn.lpn_context =
3207: wms_container_pvt.lpn_context_picked
3208: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3209: -- 5582189 dherring changed code to select picked lpns
3210: and wda.delivery_id = wnd.delivery_id
3211: and wnd.status_code in ('OP', 'PA');
3212: --and wlpn.lpn_context <> 9;

Line 3262: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked

3258: and nvl(direct_ship_flag,'N') = 'N')
3259: and wda.delivery_id = wnd.delivery_id
3260: and lpn.lpn_id = wdd2.lpn_id
3261: and lpn.outermost_lpn_id = wlpn.lpn_id
3262: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3263: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3264: --and wlpn.lpn_context <> 9
3265: -- 5582189 dherring changed code to select picked lpns
3266: and wnd.status_code in ('OP', 'PA')

Line 3263: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)

3259: and wda.delivery_id = wnd.delivery_id
3260: and lpn.lpn_id = wdd2.lpn_id
3261: and lpn.outermost_lpn_id = wlpn.lpn_id
3262: and ( wlpn.lpn_context = wms_container_pvt.lpn_context_picked
3263: OR wlpn.lpn_context = wms_container_pvt.lpn_loaded_in_stage)
3264: --and wlpn.lpn_context <> 9
3265: -- 5582189 dherring changed code to select picked lpns
3266: and wnd.status_code in ('OP', 'PA')
3267: and lpn.locator_id = milk.inventory_location_id