APPS.OE_SERVICE_WF dependencies on OE_SYS_PARAMETERS
Line 42: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
38: FROM oe_order_lines l,
39: mtl_system_items m
40: WHERE l.line_id = l_line_id
41: AND l.inventory_item_id = m.inventory_item_id 42: AND m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')); 43:
44: If NVL(l_serviceable_flag, 'N')= 'Y' Then
45: Update oe_order_lines_all
46: Set service_credit_eligible_code = l_credit_type