DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 2340: FROM MTL_SYSTEM_ITEMS_VL

2336: l_organization_id NUMBER
2337: , l_inv_item_id NUMBER
2338: ) IS
2339: SELECT serviceable_product_flag, service_item_flag
2340: FROM MTL_SYSTEM_ITEMS_VL
2341: WHERE inventory_item_id = l_inv_item_id
2342: AND organization_id = l_organization_id;
2343:
2344: CURSOR C_Get_Ship_Id (

Line 4249: FROM MTL_SYSTEM_ITEMS_VL

4245: l_organization_id NUMBER
4246: , l_inv_item_id NUMBER
4247: ) IS
4248: SELECT serviceable_product_flag
4249: FROM MTL_SYSTEM_ITEMS_VL
4250: WHERE inventory_item_id = l_inv_item_id
4251: AND organization_id = l_organization_id;
4252:
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 5527: FROM MTL_SYSTEM_ITEMS_VL

5523: l_organization_id NUMBER
5524: , l_inv_item_id NUMBER
5525: ) IS
5526: SELECT serviceable_product_flag, service_item_flag
5527: FROM MTL_SYSTEM_ITEMS_VL
5528: WHERE inventory_item_id = l_inv_item_id
5529: AND organization_id = l_organization_id;
5530:
5531: