DBA Data[Home] [Help]

APPS.GML_ACCT_GENERATE dependencies on SY_ORGN_MST

Line 210: x_whse_co_code sy_orgn_mst.co_code%TYPE;

206: retcode IN OUT NOCOPY NUMBER) AS
207: x_base_currency gl_curr_mst.CURRENCY_CODE%TYPE;
208: x_item_gl_class ic_item_mst.GL_CLASS%TYPE;
209: x_vend_gl_class po_vend_mst.VENDGL_CLASS%TYPE;
210: x_whse_co_code sy_orgn_mst.co_code%TYPE;
211: x_whse_orgn_code sy_orgn_mst.orgn_code%TYPE;
212: x_shipvend_id NUMBER;
213: x_item_no ic_item_mst.item_no%TYPE;
214: x_gl_item_id ic_item_mst.item_id%TYPE;

Line 211: x_whse_orgn_code sy_orgn_mst.orgn_code%TYPE;

207: x_base_currency gl_curr_mst.CURRENCY_CODE%TYPE;
208: x_item_gl_class ic_item_mst.GL_CLASS%TYPE;
209: x_vend_gl_class po_vend_mst.VENDGL_CLASS%TYPE;
210: x_whse_co_code sy_orgn_mst.co_code%TYPE;
211: x_whse_orgn_code sy_orgn_mst.orgn_code%TYPE;
212: x_shipvend_id NUMBER;
213: x_item_no ic_item_mst.item_no%TYPE;
214: x_gl_item_id ic_item_mst.item_id%TYPE;
215: x_to_whse ic_whse_mst.whse_code%TYPE;

Line 226: from sy_orgn_mst mst, ic_whse_mst whse

222: mtl.segment1 = mst.item_no;
223:
224: Cursor cur_opm_orgn IS
225: Select mst.co_code, whse.orgn_code, whse.whse_code
226: from sy_orgn_mst mst, ic_whse_mst whse
227: where whse.MTL_ORGANIZATION_ID = v_dest_org_id and
228: whse.orgn_code = mst.orgn_code ;
229:
230: Cursor cur_base_curr is

Line 232: from sy_orgn_mst orgn, gl_plcy_mst plcy

228: whse.orgn_code = mst.orgn_code ;
229:
230: Cursor cur_base_curr is
231: Select plcy.base_currency_code
232: from sy_orgn_mst orgn, gl_plcy_mst plcy
233: where orgn.orgn_code = x_whse_orgn_code and orgn.co_code = plcy.co_code;
234:
235: Cursor cur_opm_vend is
236: Select vendor_id, vendgl_class from po_vend_mst