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 SO_LINES

Line 46: FROM SO_LINES

42: IF (V_ORDER_CATEGORY = 'RMA') THEN
43:
44: SELECT COUNT(*)
45: INTO DUMMY
46: FROM SO_LINES
47: WHERE HEADER_ID = V_HEADER_ID
48: AND S29 IN (16, 17);
49:
50:

Line 64: FROM SO_LINES

60: MTL_SO_RMA_INTERFACE MTLSRI
61: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
62: AND MTLSRI.RMA_LINE_ID IN
63: (SELECT LINE_ID
64: FROM SO_LINES
65: WHERE HEADER_ID = V_HEADER_ID
66: AND S29 = 14);
67:
68: IF (RECEIVED_QUANTITY > 0) THEN

Line 80: SO_LINES SOL

76: ELSE
77: SELECT COUNT(*)
78: INTO DUMMY
79: FROM SO_LINE_DETAILS SLD,
80: SO_LINES SOL
81: WHERE SOL.HEADER_ID = V_HEADER_ID
82: AND SLD.LINE_ID = SOL.LINE_ID
83: AND SLD.SCHEDULE_STATUS_CODE = 'SUPPLY_RESERVED'
84: AND SLD.WIP_COMPLETED_QUANTITY < SLD.QUANTITY;

Line 103: -- to 11 (Complete). Then the lines in the SO_LINES table are also

99: -- procedure UPDATE_HEADER_INFO
100:
101: -- Update the SO_HEADERS table to reflect that the Order has been
102: -- cancelled. This is done by setting the S4 (Cancel Order) column
103: -- to 11 (Complete). Then the lines in the SO_LINES table are also
104: -- updated to reflect the order cancellation. The open_flag is set
105: -- to null, the cancelled_quantity is set to ordered_quantity
106: -- and S9 (Cancel Line) is set to 11 (Complete).
107: -- If the order is also an RMA any records in the interface that

Line 215: UPDATE SO_LINES

211: -- Set the S values for the lines, specifically set S9 (Cancel Line) to
212: -- 11 (Complete)
213: --
214:
215: UPDATE SO_LINES
216: SET LAST_UPDATED_BY = V_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = V_LAST_UPDATE_LOGIN,
218: LAST_UPDATE_DATE = SYSDATE,
219: OPEN_FLAG = NULL,

Line 287: FROM SO_LINES

283: IF V_ORDER_CATEGORY = 'RMA' THEN
284: declare
285: CURSOR rma1 IS
286: SELECT LINE_ID
287: FROM SO_LINES
288: WHERE HEADER_ID = V_HEADER_ID
289: AND S29 IN (14,16,17);
290: begin
291: FOR rma1rec IN rma1 LOOP

Line 317: FROM SO_LINES

313:
314: DELETE FROM SO_LINE_DETAILS
315: WHERE LINE_ID IN (
316: SELECT LINE_ID
317: FROM SO_LINES
318: WHERE HEADER_ID = V_HEADER_ID)
319: AND RELEASED_FLAG = 'N';
320:
321:

Line 325: FROM SO_LINES

321:
322: DELETE FROM SO_LINE_SERVICE_DETAILS
323: WHERE LINE_ID IN (
324: SELECT LINE_ID
325: FROM SO_LINES
326: WHERE HEADER_ID = V_HEADER_ID);
327:
328:
329: IF V_PRINT_ERR_MSG = 1 THEN

Line 392: (SELECT LINE_ID FROM SO_LINES

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
393: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
394: AND NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE ||'%'
395: AND V_SUBTREE_EXISTS = 1
396: UNION

Line 398: FROM SO_LINES

394: AND NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE ||'%'
395: AND V_SUBTREE_EXISTS = 1
396: UNION
397: SELECT LINE_ID
398: FROM SO_LINES
399: WHERE LINE_ID = V_LINE_ID)
400: AND SYSDATE BETWEEN SER.START_DATE_ACTIVE AND SER.END_DATE_ACTIVE;
401:
402: IF (DUMMY >= 1) THEN

Line 431: FROM SO_LINES

427: END IF;
428:
429: SELECT COUNT(*)
430: INTO DUMMY3
431: FROM SO_LINES
432: WHERE LINE_ID = V_LINE_ID
433: AND ATO_FLAG = 'Y'
434: AND ATO_LINE_ID IS NOT NULL
435: AND ITEM_TYPE_CODE <> 'SERVICE'

Line 554: FROM SO_LINES

550:
551: <>
552: SELECT ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY,0)
553: INTO TEMP_QTY
554: FROM SO_LINES
555: WHERE LINE_ID = V_LINE_ID;
556:
557: V_ALLOWABLE_CANCEL_QTY := TEMP_QTY - RECEIVED_QTY;
558: ALLOWABLE_CANCEL_QTY_TEMP := TEMP_QTY - RECEIVED_QTY;

Line 593: FROM SO_LINES

589:
590: BEGIN
591: SELECT (ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY,0))
592: INTO TEMP_QTY
593: FROM SO_LINES
594: WHERE LINE_ID = V_LINE_ID;
595:
596: V_ALLOWABLE_CANCEL_QTY := TEMP_QTY;
597: V_RESULT := 1;

Line 854: FROM SO_LINES L, SO_LINES M

850:
851: SELECT (L.ordered_quantity - nvl(L.cancelled_quantity,0)) /
852: (M.ordered_quantity - nvl(M.cancelled_quantity,0))
853: INTO TOTAL_UNRELEASED
854: FROM SO_LINES L, SO_LINES M
855: WHERE L.LINE_ID = V_LOOP_LINE_ID
856: AND M.LINE_ID = V_ATO_LOOP_LINE_ID;
857:
858: V_CONFIG_QTY := FLOOR((LD_QTY + PD_QTY) * TOTAL_UNRELEASED *

Line 868: -- If a full cancellation is begin performed then update so_lines

864:
865: ------------------------------------------------------------------------
866: -- procedure UPDATE_LINE_INFO
867: --
868: -- If a full cancellation is begin performed then update so_lines
869: -- by setting the cancelled_quantity equal to the ordered_quantity
870: -- less the greatest quantity between what was shipped and what was
871: -- invoiced.
872: -- If the line begin update is a child of a shipment schedule,

Line 877: -- Update the cancelled_quantity in so_lines adjusted by any

873: -- update the quantity on the parent shipment line.
874: -- If we have a detail shipment line, and it's an option,
875: -- once we cancel, we need to disassociate it from it's
876: -- source since we've changed the configuration.
877: -- Update the cancelled_quantity in so_lines adjusted by any
878: -- ratio differences if were have a model.
879: -- Insert a record into so_order_cancellations
880: -- Update the open_flag in so_lines, if ordered_quantity less
881: -- the cancelled_quantity is 0 then set the open_flag = ''

Line 880: -- Update the open_flag in so_lines, if ordered_quantity less

876: -- source since we've changed the configuration.
877: -- Update the cancelled_quantity in so_lines adjusted by any
878: -- ratio differences if were have a model.
879: -- Insert a record into so_order_cancellations
880: -- Update the open_flag in so_lines, if ordered_quantity less
881: -- the cancelled_quantity is 0 then set the open_flag = ''
882: -- Set the S9 (Cancel Line) column based on the open flag.
883: -- If open_flag is null then set the S9 to 11 (Complete) otherwise
884: -- set S9 to 5 (Partial).

Line 933: UPDATE SO_LINES

929: -- commit. The sql must make a *logical* change to the database
930: -- in order to actually mark the record.
931: -- Here we have chosen to cycle among the users profile_value, 0, and 1
932:
933: UPDATE SO_LINES
934: SET LAST_UPDATED_BY = DECODE(LAST_UPDATED_BY, 0, 1, 1,
935: DECODE(V_LAST_UPDATED_BY,1,0,V_LAST_UPDATED_BY),
936: V_LAST_UPDATED_BY, 0, V_LAST_UPDATED_BY)
937: WHERE (LINE_ID = V_PARENT_LINE_ID

Line 950: FROM SO_LINES

946: SELECT (ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY,0)
947: - GREATEST (NVL(SHIPPED_QUANTITY,0),
948: NVL(INVOICED_QUANTITY,0)))
949: INTO CANCEL_QTY_TMP
950: FROM SO_LINES
951: WHERE LINE_ID = V_LINE_ID;
952:
953:
954: UPDATE SO_LINES L

Line 954: UPDATE SO_LINES L

950: FROM SO_LINES
951: WHERE LINE_ID = V_LINE_ID;
952:
953:
954: UPDATE SO_LINES L
955: SET CANCELLED_QUANTITY =
956: (SELECT NVL(L.CANCELLED_QUANTITY,0) +
957: (CANCEL_QTY_TMP *
958: (L.ORDERED_QUANTITY-NVL(L.CANCELLED_QUANTITY,0))/

Line 960: FROM SO_LINES L2

956: (SELECT NVL(L.CANCELLED_QUANTITY,0) +
957: (CANCEL_QTY_TMP *
958: (L.ORDERED_QUANTITY-NVL(L.CANCELLED_QUANTITY,0))/
959: (L2.ORDERED_QUANTITY-NVL(L2.CANCELLED_QUANTITY,0)))
960: FROM SO_LINES L2
961: WHERE L2.LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID)
962: WHERE L.LINE_ID IN
963: (select line_id
964: from so_lines

Line 964: from so_lines

960: FROM SO_LINES L2
961: WHERE L2.LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID)
962: WHERE L.LINE_ID IN
963: (select line_id
964: from so_lines
965: where parent_line_id = V_SHIPMENT_SCHEDULE_LINE_ID
966: and nvl(component_code,'0') like V_COMPONENT_CODE || '%'
967: and V_SUBTREE_EXISTS = 1
968: union

Line 970: from so_lines

966: and nvl(component_code,'0') like V_COMPONENT_CODE || '%'
967: and V_SUBTREE_EXISTS = 1
968: union
969: select line_id
970: from so_lines
971: where line_id = V_SHIPMENT_SCHEDULE_LINE_ID);
972: ELSE
973: UPDATE SO_LINES
974: SET SOURCE_LINE_ID = NULL

Line 973: UPDATE SO_LINES

969: select line_id
970: from so_lines
971: where line_id = V_SHIPMENT_SCHEDULE_LINE_ID);
972: ELSE
973: UPDATE SO_LINES
974: SET SOURCE_LINE_ID = NULL
975: WHERE LINE_ID = V_LINE_ID;
976: END IF;
977: END IF;

Line 984: FROM SO_LINES

980: declare
981: CURSOR full1 IS
982: SELECT LINE_ID, HEADER_ID, ORDERED_QUANTITY, CANCELLED_QUANTITY
983: ,SHIPPED_QUANTITY,INVOICED_QUANTITY
984: FROM SO_LINES
985: WHERE LINE_ID IN
986: (select line_id
987: from so_lines
988: where parent_line_id = V_REAL_PARENT_LINE_ID

Line 987: from so_lines

983: ,SHIPPED_QUANTITY,INVOICED_QUANTITY
984: FROM SO_LINES
985: WHERE LINE_ID IN
986: (select line_id
987: from so_lines
988: where parent_line_id = V_REAL_PARENT_LINE_ID
989: and (nvl(component_code,'0') like V_COMPONENT_CODE || '%'
990: OR COMPONENT_CODE IS NULL)
991: and V_SUBTREE_EXISTS = 1

Line 994: from so_lines

990: OR COMPONENT_CODE IS NULL)
991: and V_SUBTREE_EXISTS = 1
992: union
993: select line_id
994: from so_lines
995: where line_id = V_LINE_ID
996: or service_parent_line_id = V_LINE_ID);
997:
998:

Line 1003: UPDATE SO_LINES SOL

999: begin
1000:
1001:
1002: FOR full1rec IN full1 LOOP
1003: UPDATE SO_LINES SOL
1004: SET CANCELLED_QUANTITY = ORDERED_QUANTITY
1005: - GREATEST (NVL(SHIPPED_QUANTITY,0),
1006: NVL(INVOICED_QUANTITY,0))
1007: WHERE SOL.LINE_ID = full1rec.LINE_ID;

Line 1034: UPDATE SO_LINES L

1030: ELSE
1031: IF (V_LINE_TYPE_CODE = 'DETAIL') THEN
1032: IF (V_PARENT_LINE_ID IS NULL OR V_PARENT_LINE_ID = 0) THEN
1033:
1034: UPDATE SO_LINES L
1035: SET CANCELLED_QUANTITY =
1036: (SELECT NVL(L.CANCELLED_QUANTITY,0) +
1037: (V_REQUESTED_CANCEL_QTY *
1038: (L.ORDERED_QUANTITY-NVL(L.CANCELLED_QUANTITY,0))/

Line 1040: FROM SO_LINES L2

1036: (SELECT NVL(L.CANCELLED_QUANTITY,0) +
1037: (V_REQUESTED_CANCEL_QTY *
1038: (L.ORDERED_QUANTITY-NVL(L.CANCELLED_QUANTITY,0))/
1039: (L2.ORDERED_QUANTITY-NVL(L2.CANCELLED_QUANTITY,0)))
1040: FROM SO_LINES L2
1041: WHERE L2.LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID)
1042: WHERE L.LINE_ID IN
1043: (select line_id
1044: from so_lines

Line 1044: from so_lines

1040: FROM SO_LINES L2
1041: WHERE L2.LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID)
1042: WHERE L.LINE_ID IN
1043: (select line_id
1044: from so_lines
1045: where parent_line_id = V_SHIPMENT_SCHEDULE_LINE_ID
1046: and nvl(component_code,'0') like V_COMPONENT_CODE || '%'
1047: and V_SUBTREE_EXISTS = 1
1048: union

Line 1050: from so_lines

1046: and nvl(component_code,'0') like V_COMPONENT_CODE || '%'
1047: and V_SUBTREE_EXISTS = 1
1048: union
1049: select line_id
1050: from so_lines
1051: where line_id = V_SHIPMENT_SCHEDULE_LINE_ID);
1052: ELSE
1053: UPDATE SO_LINES
1054: SET SOURCE_LINE_ID = NULL

Line 1053: UPDATE SO_LINES

1049: select line_id
1050: from so_lines
1051: where line_id = V_SHIPMENT_SCHEDULE_LINE_ID);
1052: ELSE
1053: UPDATE SO_LINES
1054: SET SOURCE_LINE_ID = NULL
1055: WHERE LINE_ID = V_LINE_ID;
1056: END IF;
1057: END IF;

Line 1061: FROM SO_LINES

1057: END IF;
1058:
1059: SELECT ORDERED_QUANTITY, CANCELLED_QUANTITY
1060: INTO L_CURRENT_ORDERED_QTY, L_CURRENT_CANCELLED_QTY
1061: FROM SO_LINES
1062: WHERE LINE_ID = V_LINE_ID;
1063:
1064: DECLARE
1065: CURSOR not_full IS

Line 1068: FROM SO_LINES

1064: DECLARE
1065: CURSOR not_full IS
1066: SELECT LINE_ID, HEADER_ID, ORDERED_QUANTITY
1067: ,CANCELLED_QUANTITY
1068: FROM SO_LINES
1069: WHERE LINE_ID IN
1070: (SELECT LINE_ID
1071: FROM SO_LINES
1072: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID

Line 1071: FROM SO_LINES

1067: ,CANCELLED_QUANTITY
1068: FROM SO_LINES
1069: WHERE LINE_ID IN
1070: (SELECT LINE_ID
1071: FROM SO_LINES
1072: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
1073: AND (NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE || '%'
1074: OR COMPONENT_CODE IS NULL)
1075: AND V_SUBTREE_EXISTS = 1

Line 1078: FROM SO_LINES

1074: OR COMPONENT_CODE IS NULL)
1075: AND V_SUBTREE_EXISTS = 1
1076: UNION
1077: SELECT LINE_ID
1078: FROM SO_LINES
1079: WHERE LINE_ID = V_LINE_ID
1080: OR SERVICE_PARENT_LINE_ID = V_LINE_ID);
1081:
1082: BEGIN

Line 1084: UPDATE SO_LINES L

1080: OR SERVICE_PARENT_LINE_ID = V_LINE_ID);
1081:
1082: BEGIN
1083: FOR not_full_rec IN not_full LOOP
1084: UPDATE SO_LINES L
1085: SET CANCELLED_QUANTITY =
1086: NVL(not_full_rec.CANCELLED_QUANTITY,0)+(V_REQUESTED_CANCEL_QTY *
1087: (not_full_rec.ORDERED_QUANTITY - NVL(not_full_rec.CANCELLED_QUANTITY,0))/
1088: (L_CURRENT_ORDERED_QTY - NVL(L_CURRENT_CANCELLED_QTY,0)))

Line 1108: FROM SO_LINES L, SO_ORDER_CANCELLATIONS SOC

1104: SYSDATE, V_CANCEL_COMMENT,
1105: NVL(L.CANCELLED_QUANTITY,0) - NVL(SUM (SOC.CANCELLED_QUANTITY),0),
1106: V_STATUS, SYSDATE, v_current_user,
1107: V_LAST_UPDATE_LOGIN
1108: FROM SO_LINES L, SO_ORDER_CANCELLATIONS SOC
1109: WHERE L.LINE_ID IN
1110: (SELECT LINE_ID
1111: FROM SO_LINES
1112: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID

Line 1111: FROM SO_LINES

1107: V_LAST_UPDATE_LOGIN
1108: FROM SO_LINES L, SO_ORDER_CANCELLATIONS SOC
1109: WHERE L.LINE_ID IN
1110: (SELECT LINE_ID
1111: FROM SO_LINES
1112: WHERE PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
1113: AND (NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE || '%'
1114: OR COMPONENT_CODE IS NULL)
1115: AND V_SUBTREE_EXISTS = 1

Line 1118: FROM SO_LINES

1114: OR COMPONENT_CODE IS NULL)
1115: AND V_SUBTREE_EXISTS = 1
1116: UNION
1117: SELECT LINE_ID
1118: FROM SO_LINES
1119: WHERE LINE_ID = V_LINE_ID
1120: OR SERVICE_PARENT_LINE_ID = V_LINE_ID)
1121: AND L.LINE_ID = SOC.LINE_ID(+)
1122: HAVING NVL(L.CANCELLED_QUANTITY,0) <> NVL(SUM (SOC.CANCELLED_QUANTITY),0)

Line 1131: UPDATE SO_LINES

1127: /*
1128: ** Fix for Bug # 532221
1129: ** Update quantity_to_invoice for non-shippable items on line Cancellation.
1130: */
1131: UPDATE SO_LINES
1132: SET QUANTITY_TO_INVOICE =
1133: DECODE(NVL(QUANTITY_TO_INVOICE,0),
1134: 0, QUANTITY_TO_INVOICE,
1135: DECODE(NVL(SHIPPED_QUANTITY,0),

Line 1146: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID

1142: AND EXISTS
1143: (SELECT 'NON SHIPPABLE ITEM'
1144: FROM MTL_SYSTEM_ITEMS MSI
1145: WHERE MSI.ORGANIZATION_ID = l_org_id
1146: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID
1147: AND MSI.SHIPPABLE_ITEM_FLAG = 'N');
1148:
1149: UPDATE SO_LINES SET OPEN_FLAG =
1150: DECODE(nvl(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0)

Line 1149: UPDATE SO_LINES SET OPEN_FLAG =

1145: WHERE MSI.ORGANIZATION_ID = l_org_id
1146: AND MSI.INVENTORY_ITEM_ID = SO_LINES.INVENTORY_ITEM_ID
1147: AND MSI.SHIPPABLE_ITEM_FLAG = 'N');
1148:
1149: UPDATE SO_LINES SET OPEN_FLAG =
1150: DECODE(nvl(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0)
1151: ,0,'',OPEN_FLAG)
1152: WHERE LINE_ID IN
1153: (select line_id

Line 1154: from so_lines

1150: DECODE(nvl(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0)
1151: ,0,'',OPEN_FLAG)
1152: WHERE LINE_ID IN
1153: (select line_id
1154: from so_lines
1155: where parent_line_id = V_REAL_PARENT_LINE_ID
1156: and (nvl(component_code,'0') like V_COMPONENT_CODE || '%'
1157: or component_code is null)
1158: and V_SUBTREE_EXISTS = 1

Line 1161: from so_lines

1157: or component_code is null)
1158: and V_SUBTREE_EXISTS = 1
1159: union
1160: select line_id
1161: from so_lines
1162: where line_id = V_LINE_ID
1163: or service_parent_line_id = V_LINE_ID);
1164:
1165: UPDATE SO_LINES

Line 1165: UPDATE SO_LINES

1161: from so_lines
1162: where line_id = V_LINE_ID
1163: or service_parent_line_id = V_LINE_ID);
1164:
1165: UPDATE SO_LINES
1166: SET LAST_UPDATED_BY = V_LAST_UPDATED_BY,
1167: LAST_UPDATE_LOGIN = V_LAST_UPDATE_LOGIN,
1168: LAST_UPDATE_DATE = SYSDATE,
1169: S1 = DECODE(OPEN_FLAG,'',DECODE(S1,18,8,S1),S1),

Line 1230: (select line_id from so_lines

1226: S29_DATE= DECODE(OPEN_FLAG,'',DECODE(S29,18,sysdate,S29_DATE),S29_DATE),
1227: S30 = DECODE(OPEN_FLAG,'',DECODE(S30,18,8,S30),S30),
1228: S30_DATE= DECODE(OPEN_FLAG,'',DECODE(S30,18,sysdate,S30_DATE),S30_DATE)
1229: WHERE LINE_ID IN
1230: (select line_id from so_lines
1231: where parent_line_id = V_REAL_PARENT_LINE_ID
1232: and (nvl(component_code,'0') like V_COMPONENT_CODE || '%'
1233: or component_code is null)
1234: and V_SUBTREE_EXISTS = 1

Line 1237: from so_lines

1233: or component_code is null)
1234: and V_SUBTREE_EXISTS = 1
1235: union
1236: select line_id
1237: from so_lines
1238: where line_id = V_LINE_ID
1239: or service_parent_line_id = V_LINE_ID);
1240:
1241: UPDATE SO_LINES

Line 1241: UPDATE SO_LINES

1237: from so_lines
1238: where line_id = V_LINE_ID
1239: or service_parent_line_id = V_LINE_ID);
1240:
1241: UPDATE SO_LINES
1242: SET S3 = DECODE(S3,18,8,S3)
1243: WHERE LINE_ID IN
1244: (select line_id from so_lines
1245: where parent_line_id = V_REAL_PARENT_LINE_ID

Line 1244: (select line_id from so_lines

1240:
1241: UPDATE SO_LINES
1242: SET S3 = DECODE(S3,18,8,S3)
1243: WHERE LINE_ID IN
1244: (select line_id from so_lines
1245: where parent_line_id = V_REAL_PARENT_LINE_ID
1246: and (nvl(component_code,'0') like V_COMPONENT_CODE || '%'
1247: or component_code is null)
1248: and V_SUBTREE_EXISTS = 1

Line 1251: from so_lines

1247: or component_code is null)
1248: and V_SUBTREE_EXISTS = 1
1249: union
1250: select line_id
1251: from so_lines
1252: where line_id = V_LINE_ID
1253: or service_parent_line_id = V_LINE_ID)
1254: AND NOT EXISTS
1255: (SELECT 'BACKORDERED PICKING LINES'

Line 1257: WHERE ORDER_LINE_ID = SO_LINES.LINE_ID

1253: or service_parent_line_id = V_LINE_ID)
1254: AND NOT EXISTS
1255: (SELECT 'BACKORDERED PICKING LINES'
1256: FROM SO_PICKING_LINES
1257: WHERE ORDER_LINE_ID = SO_LINES.LINE_ID
1258: AND PICKING_HEADER_ID = 0
1259: AND ORIGINAL_REQUESTED_QUANTITY > NVL(CANCELLED_QUANTITY,0));
1260:
1261: V_RESULT := 1;

Line 1268: -- Update so_lines by setting the cancelled_quantity = the

1264:
1265: ------------------------------------------------------------------------
1266: -- procedure UPDATE_MODEL_INFO
1267: --
1268: -- Update so_lines by setting the cancelled_quantity = the
1269: -- requested quantity and previous cancelled_quantity. Also set the
1270: -- open_flag to '' if ordered_quantity equals cancelled_quantity.
1271: -- If no backordered picking lines exist where the original requested
1272: -- quantity is greater than the cancelled quantity then set S3

Line 1319: UPDATE SO_LINES SET

1315: V_RESULT := 0;
1316: RETURN;
1317: END IF;
1318:
1319: UPDATE SO_LINES SET
1320: CANCELLED_QUANTITY =
1321: V_REQUESTED_CANCEL_QTY + NVL(CANCELLED_QUANTITY,0)
1322: WHERE LINE_ID = V_LINE_ID;
1323:

Line 1324: UPDATE SO_LINES SET

1320: CANCELLED_QUANTITY =
1321: V_REQUESTED_CANCEL_QTY + NVL(CANCELLED_QUANTITY,0)
1322: WHERE LINE_ID = V_LINE_ID;
1323:
1324: UPDATE SO_LINES SET
1325: OPEN_FLAG =
1326: DECODE ((nvl(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0)),
1327: 0, '', OPEN_FLAG)
1328: WHERE LINE_ID = V_LINE_ID;

Line 1330: UPDATE SO_LINES SET

1326: DECODE ((nvl(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0)),
1327: 0, '', OPEN_FLAG)
1328: WHERE LINE_ID = V_LINE_ID;
1329:
1330: UPDATE SO_LINES SET
1331: LAST_UPDATED_BY = V_LAST_UPDATED_BY,
1332: LAST_UPDATE_LOGIN = V_LAST_UPDATE_LOGIN,
1333: LAST_UPDATE_DATE = SYSDATE,
1334: S1 = DECODE(OPEN_FLAG,'',DECODE(S1,18,8,S1),S1),

Line 1378: UPDATE SO_LINES

1374:
1375: IF (DUMMY >= 1) THEN
1376: NULL;
1377: ELSE
1378: UPDATE SO_LINES
1379: SET S3 = DECODE(S3,18,8,S3)
1380: WHERE LINE_ID = V_LINE_ID;
1381: END IF;
1382:

Line 1383: UPDATE SO_LINES

1379: SET S3 = DECODE(S3,18,8,S3)
1380: WHERE LINE_ID = V_LINE_ID;
1381: END IF;
1382:
1383: UPDATE SO_LINES
1384: SET S1_DATE = DECODE(OPEN_FLAG,'',
1385: DECODE(S1,8,SYSDATE,S1_DATE),S1_DATE),
1386: S2_DATE = DECODE(OPEN_FLAG,'',
1387: DECODE(S2,8,SYSDATE,S2_DATE),S2_DATE),

Line 1592: FROM SO_LINES M

1588: END IF;
1589:
1590: SELECT COUNT(*)
1591: INTO DUMMY
1592: FROM SO_LINES M
1593: WHERE M.LINE_ID = V_LINK_TO_LINE_ID
1594: AND MOD((V_ORDER_QTY
1595: - NVL(V_CANCELLED_QTY,0) - V_REQUESTED_CANCEL_QTY),
1596: (M.ORDERED_QUANTITY - nvl(M.CANCELLED_QUANTITY,0))) = 0;

Line 1643: FROM SO_LINES

1639: AND OPTIONAL = 2
1640: AND (V_ORDER_QTY - NVL(V_CANCELLED_QTY,0) - V_REQUESTED_CANCEL_QTY) = 0
1641: AND NOT EXISTS
1642: (SELECT 'X'
1643: FROM SO_LINES
1644: WHERE LINK_TO_LINE_ID = V_LINK_TO_LINE_ID
1645: AND LINE_ID <> V_LINE_ID
1646: AND ORDERED_QUANTITY - NVL(CANCELLED_QUANTITY,0) > 0);
1647:

Line 1704: FROM SO_LINES P

1700: AND COMPONENT_SEQUENCE_ID = V_COMPONENT_SEQUENCE_ID
1701: AND NVL(LOW_QUANTITY,0) <=
1702: (SELECT (V_ORDER_QTY - NVL(V_CANCELLED_QTY,0) - V_REQUESTED_CANCEL_QTY) /
1703: (P.ORDERED_QUANTITY - NVL(P.CANCELLED_QUANTITY,0))
1704: FROM SO_LINES P
1705: WHERE P.LINE_ID = V_LINK_TO_LINE_ID);
1706:
1707:
1708: IF (DUMMY4 = 0) THEN