DBA Data[Home] [Help]

APPS.CSTPPINV dependencies on MTL_SYSTEM_ITEMS

Line 2267: FROM mtl_system_items

2263: l_stmt_num := 10;
2264:
2265: SELECT primary_uom_code
2266: INTO o_from_uom
2267: FROM mtl_system_items
2268: WHERE organization_id = i_from_org
2269: AND inventory_item_id = i_item_id;
2270:
2271: l_stmt_num := 20;

Line 2275: FROM mtl_system_items

2271: l_stmt_num := 20;
2272:
2273: SELECT primary_uom_code
2274: INTO o_to_uom
2275: FROM mtl_system_items
2276: WHERE organization_id = i_to_org
2277: AND inventory_item_id = i_item_id;
2278:
2279: EXCEPTION

Line 2743: FROM mtl_system_items

2739:
2740:
2741: SELECT inventory_asset_flag
2742: INTO l_asset_item
2743: FROM mtl_system_items
2744: WHERE inventory_item_id = i_item_id AND organization_id = i_txn_org_id;
2745:
2746:
2747: IF (l_asset_item = 'Y') THEN