DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT2 dependencies on MTL_SYSTEM_ITEMS

Line 1024: from mtl_system_items msi,

1020: where employee_id = v_emp_id;
1021:
1022: CURSOR item_expense_account is
1023: select msi.expense_account
1024: from mtl_system_items msi,
1025: icx_shopping_carts isc,
1026: icx_shopping_cart_lines iscl
1027: where msi.inventory_item_id(+) = iscl.item_id
1028: AND nvl(msi.ORGANIZATION_ID,

Line 1181: from mtl_system_items msi,

1177: where employee_id = v_emp_id;
1178:
1179: CURSOR item_expense_account is
1180: select msi.expense_account
1181: from mtl_system_items msi,
1182: icx_shopping_carts isc,
1183: icx_shopping_cart_lines iscl
1184: where msi.inventory_item_id(+) = iscl.item_id
1185: AND nvl(msi.ORGANIZATION_ID,