DBA Data[Home] [Help]

APPS.GMIVDX dependencies on SY_ORGN_MST

Line 271: FROM sy_docs_seq d, sy_orgn_mst o

267: l_opm_item_secondary_uom_code VARCHAR2(3);
268:
269: Cursor Cur_get_assigment_type (Vorgn_code VARCHAR2) is
270: SELECT d.assignment_type, o.co_code
271: FROM sy_docs_seq d, sy_orgn_mst o
272: WHERE o.orgn_code = Vorgn_code
273: AND o.delete_mark = 0
274: AND d.orgn_code = o.orgn_code
275: AND d.doc_type = 'DXFR'

Line 282: sy_orgn_mst o

278: Cursor Cur_get_opm_fiscal_details (Vwhse_code VARCHAR2) IS
279: SELECT p.co_code, p.sob_id, w.orgn_code, p.base_currency_code
280: FROM gl_plcy_mst p,
281: ic_whse_mst w,
282: sy_orgn_mst o
283: WHERE w.whse_code = Vwhse_code
284: AND o.orgn_code = w.orgn_code
285: AND p.co_code = o.co_code;
286: