APPS.OE_SERVICE_WF dependencies on OE_ORDER_LINES

Line 38: FROM oe_order_lines l,

34: l_credit_type := wf_engine.GetActivityAttrText(itemtype,itemkey, actid,'SERVICE_CREDIT_TYPE');
35:
36: SELECT NVL(m.serviceable_product_flag, 'N')
37: INTO l_serviceable_flag
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'));

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;