DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on GMI_ITEM_ORGANIZATIONS

Line 325: FROM gmi_item_organizations

321: l_category_set_id IN NUMBER,l_category_id IN NUMBER)
322: IS
323: CURSOR c_inventory_org IS
324: SELECT organization_id
325: FROM gmi_item_organizations
326: UNION
327: SELECT distinct p.master_organization_id
328: FROM mtl_parameters p,
329: gmi_item_organizations g

Line 329: gmi_item_organizations g

325: FROM gmi_item_organizations
326: UNION
327: SELECT distinct p.master_organization_id
328: FROM mtl_parameters p,
329: gmi_item_organizations g
330: WHERE p.organization_id = g.organization_id;
331:
332: CURSOR get_inventory_item_id(C_item_no VARCHAR2) IS
333: SELECT inventory_item_id