APPS.GMI_RESERVATION_UTIL dependencies on SY_ORGN_MST

Line 1939: FROM sy_orgn_mst sy,

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

Line 2359: , sy_orgn_mst som

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

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