APPS.GMI_RESERVATION_UTIL dependencies on IC_WHSE_MST

Line 1747: from ic_whse_mst

1743:
1744: Cursor get_whse_ctl (org_id IN NUMBER)
1745: IS
1746: select loct_ctl
1747: from ic_whse_mst
1748: where mtl_organization_id = org_id;
1749:
1750: -- end fabdi
1751:

Line 1952: ic_whse_mst wh

1948: IS
1949: SELECT sy.co_code,
1950: sy.orgn_code
1951: FROM sy_orgn_mst sy,
1952: ic_whse_mst wh
1953: WHERE sy.orgn_code = wh.orgn_code
1954: AND wh.whse_code = whse;
1955:
1956: BEGIN

Line 2337: from ic_whse_mst

2333:
2334: Cursor get_whse_ctl (org_id IN NUMBER)
2335: IS
2336: select loct_ctl
2337: from ic_whse_mst
2338: where mtl_organization_id = org_id;
2339:
2340: /* end fabdi */
2341:

Line 2372: , ic_whse_mst whse

2368: Cursor get_cust_no IS
2369: Select opc.cust_no
2370: From op_cust_mst opc
2371: , sy_orgn_mst som
2372: , ic_whse_mst whse
2373: Where whse.mtl_organization_id = l_organization_id
2374: and whse.orgn_code = som.orgn_code
2375: and som.co_code =opc.co_code
2376: and opc.of_ship_to_site_use_id(+) = l_site_use_id ;

Line 3197: From ic_whse_mst

3193:
3194: Cursor get_whse_code IS
3195: Select whse_code
3196: , orgn_code
3197: From ic_whse_mst
3198: Where mtl_organization_id = l_organization_id;
3199:
3200: Cursor get_opm_item_id (p_org_id in NUMBER
3201: , p_inv_item_id in NUMBER)

Line 3776: From ic_whse_mst w, sy_orgn_mst co

3772: l_doc_id NUMBER;
3773:
3774: Cursor get_orgn_code IS
3775: Select w.orgn_code, co.co_code
3776: From ic_whse_mst w, sy_orgn_mst co
3777: Where w.whse_code = p_whse_code
3778: AND w.orgn_code = co.orgn_code;
3779: Cursor get_doc_id IS
3780: Select mtl.sales_order_id

Line 3917: From ic_whse_mst w, sy_orgn_mst co

3913: Cursor get_orgn_code IS
3914: Select w.orgn_code
3915: , co.co_code
3916: , w.loct_ctl
3917: From ic_whse_mst w, sy_orgn_mst co
3918: Where w.whse_code = p_whse_code
3919: AND w.orgn_code = co.orgn_code;
3920: Cursor get_doc_id IS
3921: Select mtl.sales_order_id

Line 4259: From ic_whse_mst

4255: and inventory_item_id = v_apps_item_id;
4256:
4257: Cursor get_subinv IS
4258: Select whse_code
4259: From ic_whse_mst
4260: Where mtl_organization_id = v_dest_org_id;
4261:
4262: CURSOR Get_asset_sub IS
4263: Select asset_inventory

Line 4600: From ic_whse_mst

4596:
4597: /* get whse loct_ctl */
4598: Select loct_ctl
4599: Into l_whse_ctl
4600: From ic_whse_mst
4601: Where mtl_organization_id = p_mtl_organization_id;
4602:
4603: IF l_lot_ctl = 0 AND (l_loct_ctl * l_whse_ctl) = 0 THEN
4604: x_ctl_ind := 'N';

Line 4723: From ic_whse_mst

4719: Close c_reserved_qty;
4720: /* get whse loct_ctl */
4721: Select loct_ctl
4722: Into l_whse_ctl
4723: From ic_whse_mst
4724: Where mtl_organization_id = l_organization_id;
4725:
4726: l_qty_to_fulfil := p_qty_to_split;
4727: l_qty2_to_fulfil := p_qty2_to_split;