APPS.GMI_RESERVATION_UTIL dependencies on IC_WHSE_MST

Line 1743: from ic_whse_mst

1739:
1740: Cursor get_whse_ctl (org_id IN NUMBER)
1741: IS
1742: select loct_ctl
1743: from ic_whse_mst
1744: where mtl_organization_id = org_id;
1745:
1746: -- end fabdi
1747:

Line 1940: ic_whse_mst wh

1936: IS
1937: SELECT sy.co_code,
1938: sy.orgn_code
1939: FROM sy_orgn_mst sy,
1940: ic_whse_mst wh
1941: WHERE sy.orgn_code = wh.orgn_code
1942: AND wh.whse_code = whse;
1943:
1944: BEGIN

Line 2325: from ic_whse_mst

2321:
2322: Cursor get_whse_ctl (org_id IN NUMBER)
2323: IS
2324: select loct_ctl
2325: from ic_whse_mst
2326: where mtl_organization_id = org_id;
2327:
2328: /* end fabdi */
2329:

Line 2360: , ic_whse_mst whse

2356: Cursor get_cust_no IS
2357: Select opc.cust_no
2358: From op_cust_mst opc
2359: , sy_orgn_mst som
2360: , ic_whse_mst whse
2361: Where whse.mtl_organization_id = l_organization_id
2362: and whse.orgn_code = som.orgn_code
2363: and som.co_code =opc.co_code
2364: and opc.of_ship_to_site_use_id(+) = l_site_use_id ;

Line 3185: From ic_whse_mst

3181:
3182: Cursor get_whse_code IS
3183: Select whse_code
3184: , orgn_code
3185: From ic_whse_mst
3186: Where mtl_organization_id = l_organization_id;
3187:
3188: Cursor get_opm_item_id (p_org_id in NUMBER
3189: , p_inv_item_id in NUMBER)

Line 3764: From ic_whse_mst w, sy_orgn_mst co

3760: l_doc_id NUMBER;
3761:
3762: Cursor get_orgn_code IS
3763: Select w.orgn_code, co.co_code
3764: From ic_whse_mst w, sy_orgn_mst co
3765: Where w.whse_code = p_whse_code
3766: AND w.orgn_code = co.orgn_code;
3767: Cursor get_doc_id IS
3768: Select mtl.sales_order_id

Line 3905: From ic_whse_mst w, sy_orgn_mst co

3901: Cursor get_orgn_code IS
3902: Select w.orgn_code
3903: , co.co_code
3904: , w.loct_ctl
3905: From ic_whse_mst w, sy_orgn_mst co
3906: Where w.whse_code = p_whse_code
3907: AND w.orgn_code = co.orgn_code;
3908: Cursor get_doc_id IS
3909: Select mtl.sales_order_id

Line 4247: From ic_whse_mst

4243: and inventory_item_id = v_apps_item_id;
4244:
4245: Cursor get_subinv IS
4246: Select whse_code
4247: From ic_whse_mst
4248: Where mtl_organization_id = v_dest_org_id;
4249:
4250: CURSOR Get_asset_sub IS
4251: Select asset_inventory

Line 4588: From ic_whse_mst

4584:
4585: /* get whse loct_ctl */
4586: Select loct_ctl
4587: Into l_whse_ctl
4588: From ic_whse_mst
4589: Where mtl_organization_id = p_mtl_organization_id;
4590:
4591: IF l_lot_ctl = 0 AND (l_loct_ctl * l_whse_ctl) = 0 THEN
4592: x_ctl_ind := 'N';

Line 4711: From ic_whse_mst

4707: Close c_reserved_qty;
4708: /* get whse loct_ctl */
4709: Select loct_ctl
4710: Into l_whse_ctl
4711: From ic_whse_mst
4712: Where mtl_organization_id = l_organization_id;
4713:
4714: l_qty_to_fulfil := p_qty_to_split;
4715: l_qty2_to_fulfil := p_qty2_to_split;