APPS.OE_CANSRV dependencies on SO_LINES

Line 26: FROM SO_LINES

22: BEGIN
23:
24: SELECT COUNT(*)
25: INTO DUMMY
26: FROM SO_LINES
27: WHERE LINE_ID = V_LINE_ID
28: AND S25 NOT IN (8,18);
29:
30: IF DUMMY >= 1 THEN

Line 126: FROM SO_LINES

122: V_RESULT := 0;
123:
124: SELECT COUNT(*)
125: INTO DUMMY
126: FROM SO_LINES
127: WHERE LINE_ID = V_LINE_ID
128: AND (CP_SERVICE_ID IS NOT NULL
129: AND SERVICE_MASS_TXN_TEMP_ID IS NOT NULL);
130:

Line 158: FROM SO_LINES

154: END IF;
155:
156: SELECT COUNT(*)
157: INTO DUMMY2
158: FROM SO_LINES
159: WHERE LINE_ID = V_LINE_ID
160: AND (CUSTOMER_PRODUCT_ID IS NOT NULL
161: AND SERVICE_MASS_TXN_TEMP_ID IS NOT NULL);
162:

Line 229: FROM SO_LINES

225: ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY, 0) ORDERED_QUANTITY,
226: CUSTOMER_PRODUCT_ID,
227: SERVICE_MASS_TXN_TEMP_ID,
228: CP_SERVICE_ID
229: FROM SO_LINES
230: WHERE SOURCE_LINE_ID = V_LINE_ID;
231:
232:
233: BEGIN

Line 305: UPDATE SO_LINES

301: V_LAST_UPDATE_LOGIN);
302:
303: END LOOP;
304:
305: UPDATE SO_LINES
306: SET CANCELLED_QUANTITY = ORDERED_QUANTITY,
307: OPEN_FLAG = '',
308: LAST_UPDATED_BY = V_LAST_UPDATED_BY,
309: LAST_UPDATE_LOGIN = V_LAST_UPDATE_LOGIN,

Line 343: UPDATE SO_LINES

339: S29 = DECODE(OPEN_FLAG,'',DECODE(S29,18,8,S29),S29),
340: S30 = DECODE(OPEN_FLAG,'',DECODE(S30,18,8,S30),S30)
341: WHERE SOURCE_LINE_ID = V_LINE_ID;
342:
343: UPDATE SO_LINES
344: SET S1_DATE = DECODE(OPEN_FLAG,'',
345: DECODE(S1,18,TO_DATE(NULL),S1_DATE),S1_DATE),
346: S2_DATE = DECODE(OPEN_FLAG,'',
347: DECODE(S2,18,TO_DATE(NULL),S2_DATE),S2_DATE),

Line 442: FROM SO_LINES

438: l_org_id := FND_PROFILE.VALUE ('SO_ORGANIZATION_ID');
439:
440: SELECT NVL(CANCELLED_QUANTITY,0)
441: INTO V_CANCELLED_QUANTITY
442: FROM SO_LINES
443: WHERE LINE_ID = V_LINE_ID;
444:
445: V_CANCELLED_QUANTITY := V_CANCELLED_QUANTITY + V_REQUESTED_CANCEL_QTY;
446:

Line 461: FROM SO_LINES

457: AND MSRI.IN_USE_FLAG IS NULL;
458:
459: SELECT COUNT(*)
460: INTO DUMMY
461: FROM SO_LINES
462: WHERE LINE_ID = V_LINE_ID
463: AND (ORDERED_QUANTITY - V_CANCELLED_QUANTITY - V_RECEIVED_QUANTITY) > 0;
464:
465: IF DUMMY < 1 THEN

Line 477: FROM SO_LINES

473: END IF;
474:
475: SELECT COUNT(*)
476: INTO DUMMY2
477: FROM SO_LINES
478: WHERE LINE_ID = V_LINE_ID
479: AND (ORDERED_QUANTITY - V_CANCELLED_QUANTITY) > 0;
480:
481: IF DUMMY2 >= 1 THEN

Line 482: UPDATE SO_LINES

478: WHERE LINE_ID = V_LINE_ID
479: AND (ORDERED_QUANTITY - V_CANCELLED_QUANTITY) > 0;
480:
481: IF DUMMY2 >= 1 THEN
482: UPDATE SO_LINES
483: SET CANCELLED_QUANTITY = V_CANCELLED_QUANTITY,
484: S9 = 5,
485: S9_DATE = SYSDATE
486: WHERE LINE_ID = V_LINE_ID;

Line 489: UPDATE SO_LINES

485: S9_DATE = SYSDATE
486: WHERE LINE_ID = V_LINE_ID;
487:
488: ELSE
489: UPDATE SO_LINES
490: SET OPEN_FLAG = '',
491: CANCELLED_QUANTITY = V_CANCELLED_QUANTITY,
492: S1 = DECODE(S1,18,8,S1),
493: S1_DATE = DECODE(S1,18, '', S1_DATE),

Line 577: UPDATE SO_LINES

573: /*
574: ** Fix for Bug # 654734
575: ** Update quantity_to_invoice for non-shippable items on line Cancellation.
576: */
577: UPDATE SO_LINES
578: SET QUANTITY_TO_INVOICE =
579: DECODE(NVL(QUANTITY_TO_INVOICE,0),
580: 0, QUANTITY_TO_INVOICE,
581: DECODE(NVL(SHIPPED_QUANTITY,0),

Line 592: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID

588: AND EXISTS
589: (SELECT 'NON SHIPPABLE ITEM'
590: FROM MTL_SYSTEM_ITEMS MSI
591: WHERE MSI.ORGANIZATION_ID = l_org_id
592: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID
593: AND MSI.SHIPPABLE_ITEM_FLAG = 'N');
594:
595: V_RESULT := 1;
596:

Line 761: FROM SO_LINES_CANCEL_V

757: INTO V_ITEM,
758: V_BASE_LINE_NUMBER,
759: V_SHIPMENT_SCHEDULE_NUMBER,
760: V_OPTION_LINE_NUMBER
761: FROM SO_LINES_CANCEL_V
762: WHERE LINE_ID = V_LINE_ID;
763:
764:
765: END HISTORY;

Line 807: FROM SO_LINES

803: AND OESOH.LINE_ID IS NOT NULL
804: AND OESOH.HEADER_ID = V_HEADER_ID
805: AND EXISTS (
806: SELECT 'NONE_LEFT'
807: FROM SO_LINES
808: WHERE LINE_ID = OESOH.LINE_ID
809: AND ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0) +
810: GREATEST (NVL(SHIPPED_QUANTITY,0), NVL(INVOICED_QUANTITY,0)));
811: