5418: QP_PRICE_LIST_LINES_V PRICE,
5419: MTL_SYSTEM_ITEMS_KFV MTL,
5420: CSD_REPAIR_TYPES_SAR RTSAR,
5421: CS_TXN_BILLING_TYPES SAR,
5422: BOM_RESOURCES RES
5423: WHERE ROSC.repair_line_id = p_repair_line_id
5424: and ROSC.applicable_flag = 'Y'
5425: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5426: and ROSC.applied_to_est_flag = 'N'
5520: -- QP_PRICE_LIST_LINES_V PRICE,
5521: MTL_SYSTEM_ITEMS_KFV MTL,
5522: CSD_REPAIR_TYPES_SAR RTSAR,
5523: CS_TXN_BILLING_TYPES SAR,
5524: BOM_RESOURCES RES
5525: WHERE ROSC.repair_line_id = p_repair_line_id
5526: AND ROSC.applicable_flag = 'Y'
5527: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5528: AND ROSC.applied_to_est_flag = 'N'