eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CANCEL dependencies on CS_CP_SERVICES

Line 349: -- CS_CP_SERVICES (service)

345: -- Specifically it handles service checks
346: --
347: -- CS_CUSTOMER_PRODUCTS (products)
348: -- /|\
349: -- CS_CP_SERVICES (service)
350: -- /|\
351: -- CS_CP_SERVICE_TRANSACTIONS (sort of history)
352: --
353: -- Two possible situations can occur and hence the need to have

Line 357: -- by a join on CS_CUSTOMER_PRODUCTS and CS_CP_SERVICES.

353: -- Two possible situations can occur and hence the need to have
354: -- two separate sql checks. The first sql statement takes care
355: -- of the situation in which a service is associated with a product
356: -- and checks to see if the service is still active. This is done
357: -- by a join on CS_CUSTOMER_PRODUCTS and CS_CP_SERVICES.
358: -- The second possiblity is that service was ordered by itself,
359: -- a standalone service if you will. This would not have any
360: -- record in CS_CUSTOMER_PRODUCTS and hence the need to join
361: -- CS_CP_SERVICES to CS_CP_SERVICE_TRANSACTIONS.

Line 361: -- CS_CP_SERVICES to CS_CP_SERVICE_TRANSACTIONS.

357: -- by a join on CS_CUSTOMER_PRODUCTS and CS_CP_SERVICES.
358: -- The second possiblity is that service was ordered by itself,
359: -- a standalone service if you will. This would not have any
360: -- record in CS_CUSTOMER_PRODUCTS and hence the need to join
361: -- CS_CP_SERVICES to CS_CP_SERVICE_TRANSACTIONS.
362: --
363: -- RETURNS:
364: -- 1 -> if order is not cancellable
365: -- 0 -> if order is cancellable

Line 388: FROM CS_CP_SERVICES SER,

384: V_RESULT := 0;
385:
386: SELECT COUNT(*)
387: INTO DUMMY
388: FROM CS_CP_SERVICES SER,
389: CS_CUSTOMER_PRODUCTS CPS
390: WHERE SER.CUSTOMER_PRODUCT_ID = CPS.CUSTOMER_PRODUCT_ID
391: AND CPS.ORIGINAL_ORDER_LINE_ID IN
392: (SELECT LINE_ID FROM SO_LINES

Line 413: FROM CS_CP_SERVICES SER,

409: IF V_ITEM_TYPE_CODE = 'SERVICE' THEN
410:
411: SELECT COUNT(*)
412: INTO DUMMY2
413: FROM CS_CP_SERVICES SER,
414: CS_CP_SERVICE_TRANSACTIONS TRX
415: WHERE TRX.SERVICE_ORDER_LINE_ID = V_LINE_ID
416: AND TRX.CP_SERVICE_ID = SER.CP_SERVICE_ID
417: AND SYSDATE BETWEEN SER.START_DATE_ACTIVE AND SER.END_DATE_ACTIVE;