APPS.ICX_PO_REQ_ACCT2 dependencies on MTL_SYSTEM_ITEMS

Line 243: mtl_system_items msi,

239: isc.SUGGESTED_VENDOR_NAME,
240: isc.SUGGESTED_VENDOR_LOCATION
241: FROM financials_system_parameters fsp,
242: hr_employees_current_v hecv,
243: mtl_system_items msi,
244: po_requisition_lines isc
245: where isc.requisition_line_id = reqline_id
246: and msi.INVENTORY_ITEM_ID (+) = isc.ITEM_ID
247: and nvl(msi.ORGANIZATION_ID, isc.DESTINATION_ORGANIZATION_ID) = isc.DESTINATION_ORGANIZATION_ID

Line 1101: from mtl_system_items msi,

1097: where employee_id = v_emp_id;
1098:
1099: CURSOR item_expense_account is
1100: select msi.expense_account
1101: from mtl_system_items msi,
1102: icx_shopping_carts isc,
1103: icx_shopping_cart_lines iscl
1104: where msi.inventory_item_id(+) = iscl.item_id
1105: AND nvl(msi.ORGANIZATION_ID,

Line 1258: from mtl_system_items msi,

1254: where employee_id = v_emp_id;
1255:
1256: CURSOR item_expense_account is
1257: select msi.expense_account
1258: from mtl_system_items msi,
1259: po_requisition_headers poh,
1260: po_requisition_lines pol
1261: where msi.inventory_item_id(+) = pol.item_id
1262: AND nvl(msi.ORGANIZATION_ID,