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_LPN_CONTENTS

Line 1326: , wms_lpn_contents wlc

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
1330: AND wlc.inventory_item_id = p_inventory_item_id

Line 1349: , wms_lpn_contents wlc

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
1353: AND wlc.inventory_item_id = p_inventory_item_id

Line 3903: FROM wms_lpn_contents wlc, mtl_system_items msi

3899: ) RETURN VARCHAR2 IS
3900:
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)

Line 4054: , wms_lpn_contents wlc

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
4058: AND msi.inventory_item_id = wlc.inventory_item_id

Line 4137: , wms_lpn_contents wlc

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
4141: AND msi.inventory_item_id = wlc.inventory_item_id

Line 4251: FROM wms_lpn_contents wlc

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
4251: FROM wms_lpn_contents wlc
4252: WHERE wlc.parent_lpn_id = wlpn.lpn_id)
4253: AND wms_catch_weight_pvt.check_wsh_lpn( wlpn.lpn_id
4254: , p_org_id
4255: , NULL

Line 4371: wms_lpn_contents wlc

4367: , NVL(msiv.tracking_quantity_ind,'P')
4368: , NVL(msiv.dual_uom_deviation_high,0)
4369: , NVL(msiv.dual_uom_deviation_low,0)
4370: FROM mtl_system_items_kfv msiv,
4371: wms_lpn_contents wlc
4372: WHERE wlc.parent_lpn_id = p_lpn_id
4373: AND wlc.organization_id = p_org_id
4374: AND wms_catch_weight_pvt.check_ds_lpn( p_lpn_id
4375: , p_org_id

Line 4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc

4430: , NVL(msi.secondary_default_ind,'')
4431: , NVL(msi.tracking_quantity_ind,'P')
4432: , NVL(msi.dual_uom_deviation_high,0)
4433: , NVL(msi.dual_uom_deviation_low,0)
4434: FROM mtl_system_items_kfv msi, wms_lpn_contents wlc
4435: WHERE wlc.parent_lpn_id = p_lpn_id
4436: AND wlc.inventory_item_id = msi.inventory_item_id
4437: AND wlc.organization_id = msi.organization_id
4438: AND wms_catch_weight_pvt.check_wsh_lpn( p_lpn_id

Line 4610: FROM wms_lpn_contents wlc,

4606: , NVL(msi.secondary_default_ind,'')
4607: , NVL(msi.tracking_quantity_ind,'P')
4608: , NVL(msi.dual_uom_deviation_high,0)
4609: , NVL(msi.dual_uom_deviation_low,0)
4610: FROM wms_lpn_contents wlc,
4611: mtl_system_items_kfv msi
4612: WHERE wlc.parent_lpn_id = p_lpn_id
4613: AND wlc.organization_id = p_org_id
4614: AND msi.inventory_item_id = wlc.inventory_item_id