APPS.WMS_CATCH_WEIGHT_PVT dependencies on WMS_DS_CT_WT_GTEMP

Line 4239: AND NOT EXISTS (SELECT 1 FROM wms_ds_ct_wt_gtemp gt

4235: , NULL
4236: ) = 'Y'
4237: ) owlpn
4238: WHERE owlpn.license_plate_number LIKE (p_inner_lpn || '%')
4239: AND NOT EXISTS (SELECT 1 FROM wms_ds_ct_wt_gtemp gt
4240: WHERE NVL(gt.INNER_LPN_ID, gt.LPN_ID) = owlpn.lpn_id);
4241:
4242: ELSIF (UPPER(p_entry_type) = 'CT_WT_ALL') THEN
4243:

Line 4381: AND NOT EXISTS (SELECT 1 FROM wms_ds_ct_wt_gtemp gt

4377: ) = 'Y'
4378: AND msiv.inventory_item_id = wlc.inventory_item_id
4379: AND msiv.organization_id = wlc.organization_id
4380: AND msiv.concatenated_segments LIKE (p_concat_item_segment || '%' || l_append)
4381: AND NOT EXISTS (SELECT 1 FROM wms_ds_ct_wt_gtemp gt
4382: WHERE gt.inventory_item_id = wlc.inventory_item_id
4383: AND gt.org_id = wlc.organization_id
4384: AND NVL(gt.inner_lpn_id, gt.lpn_id) = wlc.parent_lpn_id);
4385: