DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS_B

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

4786: WHERE quote_header_id = p_qte_header_id
4787: AND quote_line_id = p_qte_line_id
4788: ORDER BY Line_Number;
4789:
4790: /* 2633507 - hyang: use mtl_system_items_b instead of vl */
4791:
4792: CURSOR c_Qte_Line_SVC_chk (p_inventory_item_id IN NUMBER,
4793: p_organization_id IN NUMBER) IS
4794: SELECT mtl.service_item_flag

Line 4795: FROM MTL_SYSTEM_ITEMS_B mtl

4791:
4792: CURSOR c_Qte_Line_SVC_chk (p_inventory_item_id IN NUMBER,
4793: p_organization_id IN NUMBER) IS
4794: SELECT mtl.service_item_flag
4795: FROM MTL_SYSTEM_ITEMS_B mtl
4796: WHERE mtl.inventory_item_id = p_inventory_item_id
4797: AND mtl.organization_id = p_organization_id;
4798:
4799: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS