DBA Data[Home] [Help]

APPS.OE_SERVICE_WF dependencies on OE_ORDER_LINES_ALL

Line 45: Update oe_order_lines_all

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
47: Where line_id=l_line_id;
48:
49: Else

Line 50: Update oe_order_lines_all

46: Set service_credit_eligible_code = l_credit_type
47: Where line_id=l_line_id;
48:
49: Else
50: Update oe_order_lines_all
51: Set service_credit_eligible_code = 'NONE'
52: Where line_id=l_line_id;
53:
54: End If;