DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1645: FROM MTL_SYSTEM_ITEMS_VL

1641: l_organization_id NUMBER
1642: , l_inv_item_id NUMBER
1643: ) IS
1644: SELECT serviceable_product_flag, service_item_flag
1645: FROM MTL_SYSTEM_ITEMS_VL
1646: WHERE inventory_item_id = l_inv_item_id
1647: AND organization_id = l_organization_id;
1648:
1649: CURSOR C_Get_Ship_Id (

Line 2941: FROM MTL_SYSTEM_ITEMS_VL

2937: l_organization_id NUMBER
2938: , l_inv_item_id NUMBER
2939: ) IS
2940: SELECT serviceable_product_flag
2941: FROM MTL_SYSTEM_ITEMS_VL
2942: WHERE inventory_item_id = l_inv_item_id
2943: AND organization_id = l_organization_id;
2944:
2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 4219: FROM MTL_SYSTEM_ITEMS_VL

4215: l_organization_id NUMBER
4216: , l_inv_item_id NUMBER
4217: ) IS
4218: SELECT serviceable_product_flag, service_item_flag
4219: FROM MTL_SYSTEM_ITEMS_VL
4220: WHERE inventory_item_id = l_inv_item_id
4221: AND organization_id = l_organization_id;
4222:
4223: