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

Line 1080: FROM wms_license_plate_numbers

1076:
1077: IF p_lpn_id IS NOT NULL THEN
1078: SELECT lpn_context
1079: INTO l_orig_lpn_ctx
1080: FROM wms_license_plate_numbers
1081: WHERE lpn_id = p_lpn_id;
1082: END IF;
1083:
1084: IF p_ctwt_adj_type = 'ISSUE' THEN

Line 1259: FROM wms_license_plate_numbers

1255:
1256: IF p_lpn_id IS NOT NULL THEN
1257: SELECT lpn_context
1258: INTO l_new_lpn_ctx
1259: FROM wms_license_plate_numbers
1260: WHERE lpn_id = p_lpn_id;
1261:
1262: IF (l_debug = 1) THEN
1263: print_debug('l_new_lpn_ctx: '|| l_new_lpn_ctx, 4);

Line 1267: UPDATE wms_license_plate_numbers

1263: print_debug('l_new_lpn_ctx: '|| l_new_lpn_ctx, 4);
1264: END IF;
1265:
1266: IF l_new_lpn_ctx <> l_orig_lpn_ctx THEN
1267: UPDATE wms_license_plate_numbers
1268: SET lpn_context = l_orig_lpn_ctx
1269: WHERE lpn_id = p_lpn_id;
1270:
1271: IF (l_debug = 1) THEN

Line 1325: FROM wms_license_plate_numbers wlpn

1321:
1322: CURSOR c_ds_lpn_qty IS
1323: SELECT SUM(wlc.primary_quantity)
1324: , SUM(wlc.secondary_quantity)
1325: FROM wms_license_plate_numbers wlpn
1326: , wms_lpn_contents wlc
1327: WHERE wlpn.lpn_id = p_lpn_id
1328: AND wlpn.lpn_context = 1
1329: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 1348: FROM wms_license_plate_numbers wlpn

1344:
1345: CURSOR c_stg_lpn_qty IS
1346: SELECT SUM(wlc.primary_quantity)
1347: , SUM(wlc.secondary_quantity)
1348: FROM wms_license_plate_numbers wlpn
1349: , wms_lpn_contents wlc
1350: WHERE wlpn.lpn_id = p_lpn_id
1351: AND wlpn.lpn_context = 11
1352: AND wlc.parent_lpn_id = wlpn.lpn_id

Line 1376: FROM wms_license_plate_numbers wlpn

1372: , NULL
1373: )
1374: ) primary_picked_qty
1375: , wdd2.requested_quantity_uom
1376: FROM wms_license_plate_numbers wlpn
1377: , wsh_delivery_details wdd1
1378: , wsh_delivery_assignments_v wda
1379: , wsh_delivery_details wdd2
1380: , mtl_system_items msi

Line 1788: FROM wms_license_plate_numbers wlpn

1784: , wlpn.locator_id
1785: INTO l_subinv_code
1786: , l_sub_reservable
1787: , l_locator_id
1788: FROM wms_license_plate_numbers wlpn
1789: , mtl_secondary_inventories sub
1790: WHERE wlpn.lpn_id = p_lpn_id
1791: AND sub.organization_id = wlpn.organization_id
1792: AND sub.secondary_inventory_name = wlpn.subinventory_code;

Line 2092: FROM wms_license_plate_numbers wlpn

2088: , wlpn.locator_id
2089: INTO l_subinv_code
2090: , l_sub_reservable
2091: , l_locator_id
2092: FROM wms_license_plate_numbers wlpn
2093: , mtl_secondary_inventories sub
2094: WHERE wlpn.lpn_id = p_lpn_id
2095: AND sub.organization_id = wlpn.organization_id
2096: AND sub.secondary_inventory_name = wlpn.subinventory_code;

Line 3583: FROM wms_license_plate_numbers wlpn,

3579: l_progress VARCHAR2(10) := '0';
3580:
3581: CURSOR wdd_nested_lpn_cur IS
3582: SELECT wlpn.lpn_id, wdd.delivery_detail_id
3583: FROM wms_license_plate_numbers wlpn,
3584: wsh_delivery_details wdd
3585: WHERE wlpn.organization_id = p_organization_id
3586: AND wlpn.outermost_lpn_id = p_outermost_lpn_id
3587: AND wdd.organization_id = wlpn.organization_id

Line 3653: FROM wms_license_plate_numbers

3649:
3650: BEGIN
3651: SELECT lpn_context
3652: INTO l_lpn_context
3653: FROM wms_license_plate_numbers
3654: WHERE organization_id = p_organization_id
3655: AND lpn_id = p_outermost_lpn_id;
3656: EXCEPTION
3657: WHEN NO_DATA_FOUND THEN

Line 3905: FROM wms_license_plate_numbers

3901: CURSOR c_get_lpns (p_parent_lpn_id IN NUMBER) IS
3902: SELECT 'x'
3903: FROM wms_lpn_contents wlc, mtl_system_items msi
3904: WHERE wlc.parent_lpn_id IN ( SELECT lpn_id
3905: FROM wms_license_plate_numbers
3906: START WITH lpn_id = p_lpn_id
3907: CONNECT BY PRIOR lpn_id = parent_lpn_id)
3908: AND wlc.inventory_item_id = NVL(p_inventory_item_id,wlc.inventory_item_id)
3909: AND wlc.inventory_item_id = msi.inventory_item_id

Line 3975: wms_license_plate_numbers wlpn

3971: START WITH wda2.parent_delivery_detail_id = p_lpn_wdd_id
3972: CONNECT BY PRIOR wda2.delivery_detail_id = wda2.parent_delivery_detail_id)
3973: AND EXISTS (SELECT 1
3974: FROM wsh_delivery_details wdd2,
3975: wms_license_plate_numbers wlpn
3976: WHERE wdd2.delivery_detail_id = wda.parent_delivery_detail_id
3977: AND wdd2.lpn_id = wlpn.lpn_id
3978: AND NVL(wlpn.CATCH_WEIGHT_FLAG,'N') = 'N') )
3979: AND wdd.inventory_item_id = NVL(p_inventory_item_id,inventory_item_id)

Line 4047: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2

4043: OPEN x_lpn_lov FOR
4044: SELECT UNIQUE wlpn2.license_plate_number,
4045: wlpn.outermost_lpn_id outer_lpn_id,
4046: wlpn.lpn_context
4047: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2
4048: WHERE wlpn.outermost_lpn_id = wlpn2.lpn_id
4049: AND wlpn.lpn_context = 11
4050: AND wlpn.organization_id = p_org_id
4051: AND wlpn.license_plate_number LIKE (p_lpn || '%')

Line 4053: FROM wms_license_plate_numbers wlpn3

4049: AND wlpn.lpn_context = 11
4050: AND wlpn.organization_id = p_org_id
4051: AND wlpn.license_plate_number LIKE (p_lpn || '%')
4052: AND EXISTS ( SELECT 'x'
4053: FROM wms_license_plate_numbers wlpn3
4054: , wms_lpn_contents wlc
4055: , mtl_system_items msi
4056: WHERE wlpn3.outermost_lpn_id = wlpn.outermost_lpn_id
4057: AND wlc.parent_lpn_id = wlpn3.lpn_id

Line 4068: FROM wms_license_plate_numbers wlpn,

4064: UNION
4065: SELECT UNIQUE wlpn.license_plate_number,
4066: mmtt.transfer_lpn_id,
4067: wlpn.lpn_context
4068: FROM wms_license_plate_numbers wlpn,
4069: mtl_material_transactions_temp mmtt,
4070: mtl_system_items_b msi
4071: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4072: AND mmtt.organization_id = msi.organization_id

Line 4086: FROM wms_license_plate_numbers wlpn,

4082: UNION
4083: SELECT UNIQUE wlpn.license_plate_number,
4084: mmtt.transfer_lpn_id,
4085: wlpn.lpn_context
4086: FROM wms_license_plate_numbers wlpn,
4087: mtl_material_transactions_temp mmtt,
4088: mtl_system_items_b msi
4089: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4090: AND mmtt.organization_id = msi.organization_id

Line 4095: FROM wms_license_plate_numbers wlpn2

4091: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4092: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')
4093: )
4094: AND EXISTS (SELECT wlpn2.lpn_id
4095: FROM wms_license_plate_numbers wlpn2
4096: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
4097: AND wlpn2.lpn_context = 8)
4098: AND mmtt.parent_line_id IS NULL -- exclude bulk-picked tasks
4099: AND mmtt.organization_id = p_org_id

Line 4106: FROM wms_license_plate_numbers wlpn,

4102: UNION
4103: SELECT UNIQUE wlpn.license_plate_number,
4104: mmtt.transfer_lpn_id,
4105: wlpn.lpn_context
4106: FROM wms_license_plate_numbers wlpn,
4107: mtl_material_transactions_temp mmtt,
4108: mtl_material_transactions_temp mmtt2,
4109: mtl_system_items_b msi
4110: WHERE mmtt2.inventory_item_id = msi.inventory_item_id

Line 4118: FROM wms_license_plate_numbers wlpn2

4114: )
4115: AND mmtt2.transfer_lpn_id = mmtt.content_lpn_id
4116: AND mmtt2.parent_line_id IS NULL -- exclude bulk-picked tasks
4117: AND EXISTS (SELECT wlpn2.lpn_id
4118: FROM wms_license_plate_numbers wlpn2
4119: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
4120: AND wlpn2.lpn_context = 8)
4121: AND mmtt.parent_line_id IS NULL -- exclude bulk-picked tasks
4122: AND mmtt.organization_id = p_org_id

Line 4129: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2

4125: ELSE
4126: OPEN x_lpn_lov FOR
4127: SELECT UNIQUE wlpn2.license_plate_number,wlpn.outermost_lpn_id,
4128: wlpn2.lpn_context
4129: FROM wms_license_plate_numbers wlpn, wms_license_plate_numbers wlpn2
4130: WHERE wlpn.outermost_lpn_id = wlpn2.lpn_id
4131: AND wlpn.lpn_context = 11 -- picked
4132: AND wlpn.organization_id = p_org_id
4133: AND wlpn.license_plate_number LIKE (p_lpn || '%')

Line 4136: FROM wms_license_plate_numbers wlpn3

4132: AND wlpn.organization_id = p_org_id
4133: AND wlpn.license_plate_number LIKE (p_lpn || '%')
4134: AND NVL(wlpn2.catch_weight_flag,'N') = 'N'
4135: AND EXISTS ( SELECT 'x'
4136: FROM wms_license_plate_numbers wlpn3
4137: , wms_lpn_contents wlc
4138: , mtl_system_items msi
4139: WHERE wlpn3.outermost_lpn_id = wlpn.outermost_lpn_id
4140: AND wlc.parent_lpn_id = wlpn3.lpn_id

Line 4151: FROM wms_license_plate_numbers wlpn,

4147: UNION
4148: SELECT UNIQUE wlpn.license_plate_number,
4149: mmtt.transfer_lpn_id outer_lpn,
4150: wlpn.lpn_context
4151: FROM wms_license_plate_numbers wlpn,
4152: mtl_material_transactions_temp mmtt,
4153: mtl_system_items_b msi
4154: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4155: AND mmtt.organization_id = msi.organization_id

Line 4171: wms_license_plate_numbers wlpn

4167: SELECT UNIQUE wlpn.license_plate_number,
4168: mmtt.transfer_lpn_id, wlpn.lpn_context
4169: FROM mtl_material_transactions_temp mmtt,
4170: mtl_system_items_b msi,
4171: wms_license_plate_numbers wlpn
4172: WHERE mmtt.inventory_item_id = msi.inventory_item_id
4173: AND mmtt.organization_id = msi.organization_id
4174: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4175: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')

Line 4178: FROM wms_license_plate_numbers wlpn2

4174: AND ( (msi.tracking_quantity_ind = 'PS' AND msi.secondary_default_ind <> 'F')
4175: OR (msi.tracking_quantity_ind = 'P' AND msi.ont_pricing_qty_source = 'S')
4176: )
4177: AND EXISTS (SELECT wlpn2.lpn_id
4178: FROM wms_license_plate_numbers wlpn2
4179: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
4180: AND wlpn2.lpn_context = 8)
4181: AND mmtt.organization_id = p_org_id
4182: AND mmtt.parent_line_id IS NULL -- exclude bulk-picked tasks

Line 4191: FROM wms_license_plate_numbers wlpn,

4187: UNION
4188: SELECT UNIQUE wlpn.license_plate_number,
4189: mmtt.transfer_lpn_id,
4190: wlpn.lpn_context
4191: FROM wms_license_plate_numbers wlpn,
4192: mtl_material_transactions_temp mmtt,
4193: mtl_material_transactions_temp mmtt2,
4194: mtl_system_items_b msi
4195: WHERE mmtt2.inventory_item_id = msi.inventory_item_id

Line 4203: FROM wms_license_plate_numbers wlpn2

4199: )
4200: AND mmtt2.transfer_lpn_id = mmtt.content_lpn_id
4201: AND mmtt2.parent_line_id IS NULL -- exclude bulk-picked tasks
4202: AND EXISTS (SELECT wlpn2.lpn_id
4203: FROM wms_license_plate_numbers wlpn2
4204: WHERE wlpn2.lpn_id = mmtt.content_lpn_id
4205: AND wlpn2.lpn_context = 8)
4206: AND mmtt.parent_line_id IS NULL -- exclude bulk-picked tasks
4207: AND mmtt.organization_id = p_org_id

Line 4231: FROM wms_license_plate_numbers wlpn

4227: OPEN x_lpn_lov FOR
4228: SELECT owlpn.license_plate_number, owlpn.lpn_id
4229: FROM (
4230: SELECT wlpn.license_plate_number, wlpn.lpn_id
4231: FROM wms_license_plate_numbers wlpn
4232: WHERE outermost_lpn_id = p_outer_lpn_id
4233: AND wms_catch_weight_pvt.check_ds_lpn( wlpn.lpn_id
4234: , p_org_id
4235: , NULL

Line 4246: FROM wms_license_plate_numbers wlpn

4242: ELSIF (UPPER(p_entry_type) = 'CT_WT_ALL') THEN
4243:
4244: OPEN x_lpn_lov FOR
4245: SELECT DISTINCT wlpn.license_plate_number, lpn_id
4246: FROM wms_license_plate_numbers wlpn
4247: WHERE outermost_lpn_id = p_outer_lpn_id
4248: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
4249: AND EXISTS (
4250: SELECT 1

Line 4261: wms_license_plate_numbers wlpn

4257: ) = 'Y'
4258: UNION
4259: SELECT DISTINCT license_plate_number, content_lpn_id
4260: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt,
4261: wms_license_plate_numbers wlpn
4262: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4263: AND mmtt.organization_id = p_org_id
4264: AND mmtt.parent_line_id IS NULL
4265: AND mmtt.organization_id = msi.organization_id

Line 4276: ,wms_license_plate_numbers wlpn

4272: IF (p_lpn_context = 8) THEN --Packing
4273: OPEN x_lpn_lov FOR
4274: SELECT distinct wlpn.license_plate_number, mmtt.content_lpn_id
4275: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
4276: ,wms_license_plate_numbers wlpn
4277: ,mtl_transaction_lots_temp mtlt
4278: WHERE mmtt.transfer_lpn_id = p_outer_lpn_id
4279: AND mmtt.organization_id = p_org_id
4280: AND mmtt.parent_line_id IS NULL

Line 4296: FROM wms_license_plate_numbers wlpn

4292: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%');
4293: ELSE
4294: OPEN x_lpn_lov FOR
4295: SELECT wlpn.license_plate_number, wlpn.lpn_id
4296: FROM wms_license_plate_numbers wlpn
4297: WHERE wlpn.outermost_lpn_id = p_outer_lpn_id
4298: AND wlpn.lpn_id <> wlpn.outermost_lpn_id
4299: AND wlpn.license_plate_number LIKE (p_inner_lpn || '%')
4300: AND wms_catch_weight_pvt.check_wsh_lpn( wlpn.lpn_id

Line 4547: FROM wms_license_plate_numbers wlpn,

4543: , NVL(msi.secondary_default_ind,'')
4544: , NVL(msi.tracking_quantity_ind,'P')
4545: , NVL(msi.dual_uom_deviation_high,0)
4546: , NVL(msi.dual_uom_deviation_low,0)
4547: FROM wms_license_plate_numbers wlpn,
4548: mtl_material_transactions_temp mmtt,
4549: mtl_system_items_kfv msi
4550: WHERE (mmtt.content_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id = p_lpn_id)
4551: AND mmtt.organization_id = p_org_id

Line 5187: FROM wms_license_plate_numbers

5183:
5184: BEGIN
5185: SELECT NVL(tare_weight, 0), NVL(tare_weight_uom_code, '###')
5186: INTO l_curr_tare_wt, l_curr_tare_wt_uom_code
5187: FROM wms_license_plate_numbers
5188: WHERE lpn_id = p_lpn_id
5189: AND organization_id = p_org_id;
5190: EXCEPTION
5191: WHEN NO_DATA_FOUND THEN

Line 5214: FROM wms_license_plate_numbers

5210: , to_unit => l_curr_tare_wt_uom_code
5211: , from_name => NULL
5212: , to_name => NULL))), 0)
5213: INTO l_inner_lpn_tare
5214: FROM wms_license_plate_numbers
5215: WHERE parent_lpn_id = p_lpn_id
5216: AND organization_id = p_org_id;
5217: EXCEPTION
5218: WHEN NO_DATA_FOUND THEN