APPS.GMIVQTY dependencies on SY_ORGN_MST

Line 239: FROM sy_orgn_mst co,

235: l_count NUMBER;
236: BEGIN
237: SELECT 1
238: INTO l_count
239: FROM sy_orgn_mst co,
240: sy_orgn_mst org
241: WHERE co.orgn_code = p_qty_rec.co_code AND
242: co.delete_mark = 0 AND
243: org.orgn_code = p_qty_rec.orgn_code AND

Line 240: sy_orgn_mst org

236: BEGIN
237: SELECT 1
238: INTO l_count
239: FROM sy_orgn_mst co,
240: sy_orgn_mst org
241: WHERE co.orgn_code = p_qty_rec.co_code AND
242: co.delete_mark = 0 AND
243: org.orgn_code = p_qty_rec.orgn_code AND
244: org.co_code = p_qty_rec.co_code AND

Line 282: sy_orgn_mst fo,

278: SELECT fw.loct_ctl, tw.loct_ctl
279: INTO x_from_loct_ctl, x_to_loct_ctl
280: FROM ic_whse_mst fw,
281: ic_whse_mst tw,
282: sy_orgn_mst fo,
283: sy_orgn_mst toc
284: WHERE fw.whse_code = l_from_whse AND
285: tw.whse_code = l_to_whse AND
286: fo.orgn_code = fw.orgn_code AND

Line 283: sy_orgn_mst toc

279: INTO x_from_loct_ctl, x_to_loct_ctl
280: FROM ic_whse_mst fw,
281: ic_whse_mst tw,
282: sy_orgn_mst fo,
283: sy_orgn_mst toc
284: WHERE fw.whse_code = l_from_whse AND
285: tw.whse_code = l_to_whse AND
286: fo.orgn_code = fw.orgn_code AND
287: toc.orgn_code = tw.orgn_code AND

Line 1503: FROM sy_orgn_mst

1499: Jalaj Srivastava
1500: charge accounts are tied to the company of the warehouse
1501: ********************************************************** */
1502: SELECT co_code INTO l_from_whse_co_code
1503: FROM sy_orgn_mst
1504: WHERE orgn_code = (SELECT orgn_code
1505: FROM ic_whse_mst
1506: WHERE whse_code = l_qty_rec.from_whse_code);
1507: gmf_validate_account.get_accu_acct_ids