DBA Data[Home] [Help]

APPS.GMIVDX dependencies on SY_ORGN_MST

Line 264: FROM sy_docs_seq d, sy_orgn_mst o

260: l_opm_item_secondary_uom_code VARCHAR2(3);
261:
262: Cursor Cur_get_assigment_type (Vorgn_code VARCHAR2) is
263: SELECT d.assignment_type, o.co_code
264: FROM sy_docs_seq d, sy_orgn_mst o
265: WHERE o.orgn_code = Vorgn_code
266: AND o.delete_mark = 0
267: AND d.orgn_code = o.orgn_code
268: AND d.doc_type = 'DXFR'

Line 275: sy_orgn_mst o

271: Cursor Cur_get_opm_fiscal_details (Vwhse_code VARCHAR2) IS
272: SELECT p.co_code, p.sob_id, w.orgn_code, p.base_currency_code
273: FROM gl_plcy_mst p,
274: ic_whse_mst w,
275: sy_orgn_mst o
276: WHERE w.whse_code = Vwhse_code
277: AND o.orgn_code = w.orgn_code
278: AND p.co_code = o.co_code;
279: