APPS.GMI_RESERVATION_UTIL dependencies on SY_ORGN_MST

Line 1951: FROM sy_orgn_mst sy,

1947: CURSOR Get_Orgn_Co_from_Whse (whse IN VARCHAR2)
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:

Line 2371: , sy_orgn_mst som

2367:
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

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