DBA Data[Home] [Help]

APPS.ASO_COPY_TMPL_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 460: FROM MTL_SYSTEM_ITEMS_VL

456: l_organization_id NUMBER
457: , l_inv_item_id NUMBER
458: ) IS
459: SELECT serviceable_product_flag, service_item_flag
460: FROM MTL_SYSTEM_ITEMS_VL
461: WHERE inventory_item_id = l_inv_item_id
462: AND organization_id = l_organization_id;
463:
464: CURSOR C_Get_Ship_Id (

Line 1584: FROM MTL_SYSTEM_ITEMS_VL

1580: l_organization_id NUMBER
1581: , l_inv_item_id NUMBER
1582: ) IS
1583: SELECT serviceable_product_flag
1584: FROM MTL_SYSTEM_ITEMS_VL
1585: WHERE inventory_item_id = l_inv_item_id
1586: AND organization_id = l_organization_id;
1587:
1588: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;