DBA Data[Home] [Help]

APPS.CS_UPDATE_WARRANTY_DATES dependencies on MTL_SYSTEM_ITEMS

Line 13: FROM CS_CP_SERVICES srv, MTL_SYSTEM_ITEMS srv_item

9: CURSOR CP_Service_Cursor IS
10: SELECT srv.service_inventory_item_id item_id,
11: srv_item.service_duration duration_quantity,
12: srv_item.service_duration_period_code duration_uom
13: FROM CS_CP_SERVICES srv, MTL_SYSTEM_ITEMS srv_item
14: WHERE srv.customer_product_id = X_Customer_Product_ID
15: AND srv.warranty_flag = 'Y'
16: AND srv.service_inventory_item_id = srv_item.inventory_item_id (+)
17: FOR UPDATE OF srv.start_date_active,