[Home] [Help]
204: PROCEDURE get_opm_account(v_dest_org_id NUMBER, v_apps_item_id NUMBER,
205: v_vendor_site_id NUMBER, v_opm_account_type VARCHAR2,
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;
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;
216:
217: Cursor cur_opm_item IS
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;
216:
217: Cursor cur_opm_item IS
218: Select mst.item_no , mst.item_id, mst.gl_class
215: x_to_whse ic_whse_mst.whse_code%TYPE;
216:
217: Cursor cur_opm_item IS
218: Select mst.item_no , mst.item_id, mst.gl_class
219: from ic_item_mst mst, mtl_system_items mtl
220: where mtl.inventory_item_id = v_apps_item_id and
221: mtl.organization_id = v_dest_org_id and
222: mtl.segment1 = mst.item_no;
223:
236: Select vendor_id, vendgl_class from po_vend_mst
237: where of_vendor_site_id = v_vendor_site_id;
238:
239: /* Bug 2312653 RVK */
240: Cursor category_ids(p_item_id ic_item_mst.item_id%TYPE)
241: IS
242: SELECT gic.item_id, gcs.opm_class, gic.category_id
243: FROM gmi_category_sets gcs, gmi_item_categories gic
244: WHERE gic.item_id = p_item_id