DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 4544: /* 2633507 - hyang: use mtl_system_items_b instead of vl */

4540: WHERE quote_header_id = p_qte_header_id
4541: AND quote_line_id = p_qte_line_id
4542: ORDER BY Line_Number;
4543:
4544: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
4545:
4546: CURSOR c_Qte_Line_SVC_chk (p_inventory_item_id IN NUMBER,
4547: p_organization_id IN NUMBER) IS
4548: SELECT mtl.service_item_flag

Line 4549: FROM MTL_SYSTEM_ITEMS_B mtl

4545:
4546: CURSOR c_Qte_Line_SVC_chk (p_inventory_item_id IN NUMBER,
4547: p_organization_id IN NUMBER) IS
4548: SELECT mtl.service_item_flag
4549: FROM MTL_SYSTEM_ITEMS_B mtl
4550: WHERE mtl.inventory_item_id = p_inventory_item_id
4551: AND mtl.organization_id = p_organization_id;
4552:
4553: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS