DBA Data[Home] [Help]

APPS.ICX_REQ_SUBMIT dependencies on MTL_SYSTEM_ITEMS

Line 114: from mtl_system_items_kfv

110: where employee_id = v_employee_id;
111:
112: cursor item_names(id number, org number) is
113: select concatenated_segments
114: from mtl_system_items_kfv
115: where INVENTORY_ITEM_ID = id
116: and ORGANIZATION_ID = org;
117:
118: cursor getCurrency is

Line 801: mtl_system_items msi,

797: v_oo_id number) is
798: select hecv.default_code_combination_id employee_default_account_id,
799: msi.expense_account
800: from hr_employees_current_v hecv,
801: mtl_system_items msi,
802: icx_shopping_carts isc,
803: icx_shopping_cart_lines iscl
804: where msi.INVENTORY_ITEM_ID (+) = iscl.ITEM_ID
805: and nvl(msi.ORGANIZATION_ID,