APPS.WMS_CATCH_WEIGHT_PVT dependencies on WMS_DS_CT_WT_GTEMP

Line 1720: AND not exists (SELECT 1 FROM WMS_DS_CT_WT_GTEMP gt

1716: AND msi.ont_pricing_qty_source = 'S'
1717: )
1718: ) owlpn
1719: WHERE owlpn.license_plate_number LIKE (p_inner_lpn || '%')
1720: AND not exists (SELECT 1 FROM WMS_DS_CT_WT_GTEMP gt
1721: WHERE nvl(gt.INNER_LPN_ID, gt.LPN_ID) = owlpn.lpn_id);
1722:
1723: ELSIF (UPPER(p_entry_type) = 'CT_WT_ALL') THEN
1724:

Line 1896: AND not exists (SELECT 1 FROM WMS_DS_CT_WT_GTEMP gt

1892: AND msi.ont_pricing_qty_source = 'S'
1893: AND msiv.inventory_item_id = msi.inventory_item_id
1894: AND msiv.organization_id = msi.organization_id
1895: AND msiv.concatenated_segments LIKE (p_concat_item_segment || '%')
1896: AND not exists (SELECT 1 FROM WMS_DS_CT_WT_GTEMP gt
1897: WHERE gt.inventory_item_id = wlc.inventory_item_id
1898: AND gt.org_id = wlc.organization_id
1899: AND nvl(gt.INNER_LPN_ID, gt.LPN_ID) = wlc.parent_lpn_id);
1900: