APPS.GMI_SHIPPING_UTIL dependencies on IC_WHSE_MST

Line 777: From ic_whse_mst

773: and shipped_quantity = (-1)*itp.trans_qty);
774:
775: CURSOR get_whse IS
776: Select loct_ctl
777: From ic_whse_mst
778: Where mtl_organization_id = p_shipping_line.organization_id;
779:
780: --BEGIN BUG#2736088 V. Ajay Kumar
781: --Removed the refence to "apps".

Line 2031: , ic_whse_mst whse

2027: , opm.loct_ctl
2028: , whse.loct_ctl
2029: From ic_item_mst opm
2030: , mtl_system_items mtl
2031: , ic_whse_mst whse
2032: Where mtl.inventory_item_id = p_inventory_item_id
2033: and mtl.organization_id = p_organization_id
2034: and mtl.segment1 = opm.item_no
2035: and whse.mtl_organization_id = p_organization_id; */

Line 3604: From ic_whse_mst

3600:
3601: /* get whse loct_ctl */
3602: Select loct_ctl
3603: Into l_whse_ctl
3604: From ic_whse_mst
3605: Where mtl_organization_id = l_organization_id;
3606:
3607: l_qty_to_fulfil := l_orig_qty - p_qty_to_split;
3608: l_qty2_to_fulfil := l_orig_qty2 - p_qty2_to_split;

Line 4349: From ic_whse_mst

4345:
4346: /* get whse loct_ctl */
4347: Select loct_ctl
4348: Into l_whse_ctl
4349: From ic_whse_mst
4350: Where mtl_organization_id = p_mtl_organization_id;
4351:
4352: IF (l_loct_ctl * l_whse_ctl) = 0 THEN
4353: x_ctl_ind := 'N';