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.BOMPLDCI dependencies on MTL_SYSTEM_ITEMS

Line 124: mtl_system_items_interface.segment1%TYPE

120: and FS.SEGMENT_NAME = P.CONFIG_SEGMENT_NAME
121: and FS.APPLICATION_ID = 401 /* INV */
122: and FS.FLEX_VALUE_SET_ID = FV.FLEX_VALUE_SET_ID;
123: TYPE SIsegTYPE is TABLE of
124: mtl_system_items_interface.segment1%TYPE
125: index by BINARY_INTEGER;
126: seg SIsegTYPE;
127: ind BINARY_INTEGER;
128: BEGIN

Line 213: ** Insert a row into the new mtl_system_items_interface table.

209: END IF;
210:
211:
212: /*
213: ** Insert a row into the new mtl_system_items_interface table.
214: */
215:
216: table_name := 'INSERT MTL_SYSTEM_ITEMS_IF ';
217: stmt_num := 20;

Line 216: table_name := 'INSERT MTL_SYSTEM_ITEMS_IF ';

212: /*
213: ** Insert a row into the new mtl_system_items_interface table.
214: */
215:
216: table_name := 'INSERT MTL_SYSTEM_ITEMS_IF ';
217: stmt_num := 20;
218: insert into MTL_SYSTEM_ITEMS_INTERFACE
219: (INVENTORY_ITEM_ID,
220: ORGANIZATION_ID,

Line 218: insert into MTL_SYSTEM_ITEMS_INTERFACE

214: */
215:
216: table_name := 'INSERT MTL_SYSTEM_ITEMS_IF ';
217: stmt_num := 20;
218: insert into MTL_SYSTEM_ITEMS_INTERFACE
219: (INVENTORY_ITEM_ID,
220: ORGANIZATION_ID,
221: LAST_UPDATE_DATE,
222: LAST_UPDATED_BY,

Line 276: select MTL_SYSTEM_ITEMS_S.NEXTVAL,

272: ITEM_TYPE,
273: CUSTOMER_ORDER_ENABLED_FLAG,
274: INTERNAL_ORDER_ENABLED_FLAG
275: )
276: select MTL_SYSTEM_ITEMS_S.NEXTVAL,
277: D.ORGANIZATION_ID,
278: SYSDATE, /* LAST_UPDATE_DATE */
279: 1, /* LAST_UPDATED_BY */
280: SYSDATE, /* CREATION_DATE */

Line 290: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

286: 3 = Replace with order header num/line num/delivery */
287: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT1',
288: decode(P.CONFIG_NUMBER_METHOD_TYPE,
289: 1,SUBSTRB(S.SEGMENT1,1,decode(GREATEST(FV.MAXIMUM_SIZE,
290: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
291: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
292: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
293: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
294: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 291: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

287: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT1',
288: decode(P.CONFIG_NUMBER_METHOD_TYPE,
289: 1,SUBSTRB(S.SEGMENT1,1,decode(GREATEST(FV.MAXIMUM_SIZE,
290: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
291: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
292: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
293: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
294: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
295: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 292: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

288: decode(P.CONFIG_NUMBER_METHOD_TYPE,
289: 1,SUBSTRB(S.SEGMENT1,1,decode(GREATEST(FV.MAXIMUM_SIZE,
290: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
291: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
292: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
293: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
294: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
295: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
296: S.SEGMENT1),S.SEGMENT1),

Line 300: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

296: S.SEGMENT1),S.SEGMENT1),
297: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT2',
298: decode(P.CONFIG_NUMBER_METHOD_TYPE,
299: 1,SUBSTRB(S.SEGMENT2,1,decode(GREATEST(FV.MAXIMUM_SIZE,
300: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
301: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
302: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
303: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
304: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 301: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

297: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT2',
298: decode(P.CONFIG_NUMBER_METHOD_TYPE,
299: 1,SUBSTRB(S.SEGMENT2,1,decode(GREATEST(FV.MAXIMUM_SIZE,
300: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
301: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
302: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
303: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
304: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
305: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 302: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

298: decode(P.CONFIG_NUMBER_METHOD_TYPE,
299: 1,SUBSTRB(S.SEGMENT2,1,decode(GREATEST(FV.MAXIMUM_SIZE,
300: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
301: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
302: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
303: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
304: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
305: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
306: S.SEGMENT2),S.SEGMENT2),

Line 310: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

306: S.SEGMENT2),S.SEGMENT2),
307: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT3',
308: decode(P.CONFIG_NUMBER_METHOD_TYPE,
309: 1,SUBSTRB(S.SEGMENT3,1,decode(GREATEST(FV.MAXIMUM_SIZE,
310: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
311: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
312: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
313: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
314: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 311: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

307: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT3',
308: decode(P.CONFIG_NUMBER_METHOD_TYPE,
309: 1,SUBSTRB(S.SEGMENT3,1,decode(GREATEST(FV.MAXIMUM_SIZE,
310: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
311: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
312: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
313: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
314: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
315: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 312: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

308: decode(P.CONFIG_NUMBER_METHOD_TYPE,
309: 1,SUBSTRB(S.SEGMENT3,1,decode(GREATEST(FV.MAXIMUM_SIZE,
310: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
311: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
312: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
313: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
314: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
315: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
316: S.SEGMENT3),S.SEGMENT3),

Line 320: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

316: S.SEGMENT3),S.SEGMENT3),
317: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT4',
318: decode(P.CONFIG_NUMBER_METHOD_TYPE,
319: 1,SUBSTRB(S.SEGMENT4,1,decode(GREATEST(FV.MAXIMUM_SIZE,
320: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
321: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
322: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
323: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
324: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 321: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

317: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT4',
318: decode(P.CONFIG_NUMBER_METHOD_TYPE,
319: 1,SUBSTRB(S.SEGMENT4,1,decode(GREATEST(FV.MAXIMUM_SIZE,
320: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
321: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
322: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
323: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
324: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
325: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 322: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

318: decode(P.CONFIG_NUMBER_METHOD_TYPE,
319: 1,SUBSTRB(S.SEGMENT4,1,decode(GREATEST(FV.MAXIMUM_SIZE,
320: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
321: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
322: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
323: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
324: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
325: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
326: S.SEGMENT4),S.SEGMENT4),

Line 330: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

326: S.SEGMENT4),S.SEGMENT4),
327: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT5',
328: decode(P.CONFIG_NUMBER_METHOD_TYPE,
329: 1,SUBSTRB(S.SEGMENT5,1,decode(GREATEST(FV.MAXIMUM_SIZE,
330: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
331: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
332: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
333: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
334: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 331: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

327: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT5',
328: decode(P.CONFIG_NUMBER_METHOD_TYPE,
329: 1,SUBSTRB(S.SEGMENT5,1,decode(GREATEST(FV.MAXIMUM_SIZE,
330: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
331: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
332: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
333: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
334: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
335: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 332: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

328: decode(P.CONFIG_NUMBER_METHOD_TYPE,
329: 1,SUBSTRB(S.SEGMENT5,1,decode(GREATEST(FV.MAXIMUM_SIZE,
330: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
331: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
332: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
333: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
334: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
335: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
336: S.SEGMENT5),S.SEGMENT5),

Line 340: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

336: S.SEGMENT5),S.SEGMENT5),
337: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT6',
338: decode(P.CONFIG_NUMBER_METHOD_TYPE,
339: 1,SUBSTRB(S.SEGMENT6,1,decode(GREATEST(FV.MAXIMUM_SIZE,
340: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
341: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
342: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
343: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
344: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 341: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

337: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT6',
338: decode(P.CONFIG_NUMBER_METHOD_TYPE,
339: 1,SUBSTRB(S.SEGMENT6,1,decode(GREATEST(FV.MAXIMUM_SIZE,
340: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
341: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
342: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
343: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
344: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
345: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 342: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

338: decode(P.CONFIG_NUMBER_METHOD_TYPE,
339: 1,SUBSTRB(S.SEGMENT6,1,decode(GREATEST(FV.MAXIMUM_SIZE,
340: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
341: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
342: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
343: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
344: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
345: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
346: S.SEGMENT6),S.SEGMENT6),

Line 350: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

346: S.SEGMENT6),S.SEGMENT6),
347: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT7',
348: decode(P.CONFIG_NUMBER_METHOD_TYPE,
349: 1,SUBSTRB(S.SEGMENT7,1,decode(GREATEST(FV.MAXIMUM_SIZE,
350: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
351: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
352: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
353: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
354: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 351: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

347: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT7',
348: decode(P.CONFIG_NUMBER_METHOD_TYPE,
349: 1,SUBSTRB(S.SEGMENT7,1,decode(GREATEST(FV.MAXIMUM_SIZE,
350: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
351: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
352: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
353: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
354: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
355: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 352: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

348: decode(P.CONFIG_NUMBER_METHOD_TYPE,
349: 1,SUBSTRB(S.SEGMENT7,1,decode(GREATEST(FV.MAXIMUM_SIZE,
350: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
351: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
352: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
353: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
354: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
355: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
356: S.SEGMENT7),S.SEGMENT7),

Line 360: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

356: S.SEGMENT7),S.SEGMENT7),
357: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT8',
358: decode(P.CONFIG_NUMBER_METHOD_TYPE,
359: 1,SUBSTRB(S.SEGMENT8,1,decode(GREATEST(FV.MAXIMUM_SIZE,
360: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
361: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
362: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
363: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
364: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 361: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

357: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT8',
358: decode(P.CONFIG_NUMBER_METHOD_TYPE,
359: 1,SUBSTRB(S.SEGMENT8,1,decode(GREATEST(FV.MAXIMUM_SIZE,
360: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
361: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
362: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
363: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
364: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
365: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 362: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

358: decode(P.CONFIG_NUMBER_METHOD_TYPE,
359: 1,SUBSTRB(S.SEGMENT8,1,decode(GREATEST(FV.MAXIMUM_SIZE,
360: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
361: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
362: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
363: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
364: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
365: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
366: S.SEGMENT8),S.SEGMENT8),

Line 370: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

366: S.SEGMENT8),S.SEGMENT8),
367: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT9',
368: decode(P.CONFIG_NUMBER_METHOD_TYPE,
369: 1,SUBSTRB(S.SEGMENT9,1,decode(GREATEST(FV.MAXIMUM_SIZE,
370: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
371: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
372: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
373: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
374: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 371: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

367: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT9',
368: decode(P.CONFIG_NUMBER_METHOD_TYPE,
369: 1,SUBSTRB(S.SEGMENT9,1,decode(GREATEST(FV.MAXIMUM_SIZE,
370: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
371: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
372: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
373: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
374: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
375: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 372: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

368: decode(P.CONFIG_NUMBER_METHOD_TYPE,
369: 1,SUBSTRB(S.SEGMENT9,1,decode(GREATEST(FV.MAXIMUM_SIZE,
370: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
371: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
372: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
373: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
374: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
375: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
376: S.SEGMENT9),S.SEGMENT9),

Line 380: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

376: S.SEGMENT9),S.SEGMENT9),
377: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT10',
378: decode(P.CONFIG_NUMBER_METHOD_TYPE,
379: 1,SUBSTRB(S.SEGMENT10,1,decode(GREATEST(FV.MAXIMUM_SIZE,
380: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
381: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
382: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
383: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
384: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 381: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

377: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT10',
378: decode(P.CONFIG_NUMBER_METHOD_TYPE,
379: 1,SUBSTRB(S.SEGMENT10,1,decode(GREATEST(FV.MAXIMUM_SIZE,
380: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
381: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
382: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
383: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
384: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
385: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 382: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

378: decode(P.CONFIG_NUMBER_METHOD_TYPE,
379: 1,SUBSTRB(S.SEGMENT10,1,decode(GREATEST(FV.MAXIMUM_SIZE,
380: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
381: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
382: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
383: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
384: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
385: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
386: S.SEGMENT10),S.SEGMENT10),

Line 390: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

386: S.SEGMENT10),S.SEGMENT10),
387: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT11',
388: decode(P.CONFIG_NUMBER_METHOD_TYPE,
389: 1,SUBSTRB(S.SEGMENT11,1,decode(GREATEST(FV.MAXIMUM_SIZE,
390: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
391: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
392: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
393: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
394: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 391: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

387: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT11',
388: decode(P.CONFIG_NUMBER_METHOD_TYPE,
389: 1,SUBSTRB(S.SEGMENT11,1,decode(GREATEST(FV.MAXIMUM_SIZE,
390: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
391: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
392: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
393: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
394: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
395: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 392: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

388: decode(P.CONFIG_NUMBER_METHOD_TYPE,
389: 1,SUBSTRB(S.SEGMENT11,1,decode(GREATEST(FV.MAXIMUM_SIZE,
390: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
391: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
392: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
393: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
394: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
395: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
396: S.SEGMENT11),S.SEGMENT11),

Line 400: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

396: S.SEGMENT11),S.SEGMENT11),
397: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT12',
398: decode(P.CONFIG_NUMBER_METHOD_TYPE,
399: 1,SUBSTRB(S.SEGMENT12,1,decode(GREATEST(FV.MAXIMUM_SIZE,
400: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
401: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
402: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
403: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
404: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 401: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

397: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT12',
398: decode(P.CONFIG_NUMBER_METHOD_TYPE,
399: 1,SUBSTRB(S.SEGMENT12,1,decode(GREATEST(FV.MAXIMUM_SIZE,
400: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
401: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
402: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
403: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
404: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
405: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 402: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

398: decode(P.CONFIG_NUMBER_METHOD_TYPE,
399: 1,SUBSTRB(S.SEGMENT12,1,decode(GREATEST(FV.MAXIMUM_SIZE,
400: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
401: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
402: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
403: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
404: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
405: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
406: S.SEGMENT12),S.SEGMENT12),

Line 410: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

406: S.SEGMENT12),S.SEGMENT12),
407: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT13',
408: decode(P.CONFIG_NUMBER_METHOD_TYPE,
409: 1,SUBSTRB(S.SEGMENT13,1,decode(GREATEST(FV.MAXIMUM_SIZE,
410: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
411: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
412: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
413: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
414: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 411: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

407: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT13',
408: decode(P.CONFIG_NUMBER_METHOD_TYPE,
409: 1,SUBSTRB(S.SEGMENT13,1,decode(GREATEST(FV.MAXIMUM_SIZE,
410: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
411: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
412: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
413: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
414: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
415: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 412: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

408: decode(P.CONFIG_NUMBER_METHOD_TYPE,
409: 1,SUBSTRB(S.SEGMENT13,1,decode(GREATEST(FV.MAXIMUM_SIZE,
410: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
411: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
412: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
413: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
414: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
415: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
416: S.SEGMENT13),S.SEGMENT13),

Line 420: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

416: S.SEGMENT13),S.SEGMENT13),
417: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT14',
418: decode(P.CONFIG_NUMBER_METHOD_TYPE,
419: 1,SUBSTRB(S.SEGMENT14,1,decode(GREATEST(FV.MAXIMUM_SIZE,
420: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
421: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
422: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
423: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
424: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 421: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

417: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT14',
418: decode(P.CONFIG_NUMBER_METHOD_TYPE,
419: 1,SUBSTRB(S.SEGMENT14,1,decode(GREATEST(FV.MAXIMUM_SIZE,
420: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
421: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
422: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
423: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
424: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
425: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 422: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

418: decode(P.CONFIG_NUMBER_METHOD_TYPE,
419: 1,SUBSTRB(S.SEGMENT14,1,decode(GREATEST(FV.MAXIMUM_SIZE,
420: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
421: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
422: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
423: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
424: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
425: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
426: S.SEGMENT14),S.SEGMENT14),

Line 430: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

426: S.SEGMENT14),S.SEGMENT14),
427: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT15',
428: decode(P.CONFIG_NUMBER_METHOD_TYPE,
429: 1,SUBSTRB(S.SEGMENT15,1,decode(GREATEST(FV.MAXIMUM_SIZE,
430: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
431: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
432: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
433: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
434: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 431: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

427: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT15',
428: decode(P.CONFIG_NUMBER_METHOD_TYPE,
429: 1,SUBSTRB(S.SEGMENT15,1,decode(GREATEST(FV.MAXIMUM_SIZE,
430: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
431: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
432: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
433: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
434: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
435: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 432: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

428: decode(P.CONFIG_NUMBER_METHOD_TYPE,
429: 1,SUBSTRB(S.SEGMENT15,1,decode(GREATEST(FV.MAXIMUM_SIZE,
430: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
431: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
432: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
433: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
434: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
435: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
436: S.SEGMENT15),S.SEGMENT15),

Line 440: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

436: S.SEGMENT15),S.SEGMENT15),
437: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT16',
438: decode(P.CONFIG_NUMBER_METHOD_TYPE,
439: 1,SUBSTRB(S.SEGMENT16,1,decode(GREATEST(FV.MAXIMUM_SIZE,
440: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
441: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
442: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
443: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
444: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 441: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

437: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT16',
438: decode(P.CONFIG_NUMBER_METHOD_TYPE,
439: 1,SUBSTRB(S.SEGMENT16,1,decode(GREATEST(FV.MAXIMUM_SIZE,
440: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
441: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
442: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
443: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
444: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
445: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 442: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

438: decode(P.CONFIG_NUMBER_METHOD_TYPE,
439: 1,SUBSTRB(S.SEGMENT16,1,decode(GREATEST(FV.MAXIMUM_SIZE,
440: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
441: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
442: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
443: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
444: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
445: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
446: S.SEGMENT16),S.SEGMENT16),

Line 450: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

446: S.SEGMENT16),S.SEGMENT16),
447: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT17',
448: decode(P.CONFIG_NUMBER_METHOD_TYPE,
449: 1,SUBSTRB(S.SEGMENT17,1,decode(GREATEST(FV.MAXIMUM_SIZE,
450: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
451: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
452: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
453: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
454: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 451: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

447: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT17',
448: decode(P.CONFIG_NUMBER_METHOD_TYPE,
449: 1,SUBSTRB(S.SEGMENT17,1,decode(GREATEST(FV.MAXIMUM_SIZE,
450: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
451: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
452: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
453: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
454: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
455: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 452: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

448: decode(P.CONFIG_NUMBER_METHOD_TYPE,
449: 1,SUBSTRB(S.SEGMENT17,1,decode(GREATEST(FV.MAXIMUM_SIZE,
450: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
451: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
452: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
453: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
454: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
455: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
456: S.SEGMENT17),S.SEGMENT17),

Line 460: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

456: S.SEGMENT17),S.SEGMENT17),
457: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT18',
458: decode(P.CONFIG_NUMBER_METHOD_TYPE,
459: 1,SUBSTRB(S.SEGMENT18,1,decode(GREATEST(FV.MAXIMUM_SIZE,
460: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
461: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
462: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
463: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
464: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 461: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

457: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT18',
458: decode(P.CONFIG_NUMBER_METHOD_TYPE,
459: 1,SUBSTRB(S.SEGMENT18,1,decode(GREATEST(FV.MAXIMUM_SIZE,
460: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
461: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
462: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
463: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
464: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
465: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 462: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

458: decode(P.CONFIG_NUMBER_METHOD_TYPE,
459: 1,SUBSTRB(S.SEGMENT18,1,decode(GREATEST(FV.MAXIMUM_SIZE,
460: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
461: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
462: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
463: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
464: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
465: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
466: S.SEGMENT18),S.SEGMENT18),

Line 470: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

466: S.SEGMENT18),S.SEGMENT18),
467: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT19',
468: decode(P.CONFIG_NUMBER_METHOD_TYPE,
469: 1,SUBSTRB(S.SEGMENT19,1,decode(GREATEST(FV.MAXIMUM_SIZE,
470: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
471: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
472: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
473: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
474: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 471: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

467: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT19',
468: decode(P.CONFIG_NUMBER_METHOD_TYPE,
469: 1,SUBSTRB(S.SEGMENT19,1,decode(GREATEST(FV.MAXIMUM_SIZE,
470: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
471: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
472: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
473: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
474: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
475: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 472: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

468: decode(P.CONFIG_NUMBER_METHOD_TYPE,
469: 1,SUBSTRB(S.SEGMENT19,1,decode(GREATEST(FV.MAXIMUM_SIZE,
470: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
471: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
472: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
473: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1 || ci_del || D.USER_LINE_NUM,
474: L.SEGMENT1 || ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
475: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
476: S.SEGMENT19),S.SEGMENT19),

Line 480: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||

476: S.SEGMENT19),S.SEGMENT19),
477: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT20',
478: decode(P.CONFIG_NUMBER_METHOD_TYPE,
479: 1,SUBSTRB(S.SEGMENT20,1,decode(GREATEST(FV.MAXIMUM_SIZE,
480: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
481: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
482: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
483: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1|| ci_del || D.USER_LINE_NUM,
484: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),

Line 481: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

477: decode(FS.APPLICATION_COLUMN_NAME, 'SEGMENT20',
478: decode(P.CONFIG_NUMBER_METHOD_TYPE,
479: 1,SUBSTRB(S.SEGMENT20,1,decode(GREATEST(FV.MAXIMUM_SIZE,
480: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
481: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
482: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
483: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1|| ci_del || D.USER_LINE_NUM,
484: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
485: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

Line 482: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),

478: decode(P.CONFIG_NUMBER_METHOD_TYPE,
479: 1,SUBSTRB(S.SEGMENT20,1,decode(GREATEST(FV.MAXIMUM_SIZE,
480: 40),40,FV.MAXIMUM_SIZE-1-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),39-length(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL))) ||ci_del||
481: TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
482: 2, TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
483: 3, DECODE(D.USER_DELIVERY, NULL, L.SEGMENT1|| ci_del || D.USER_LINE_NUM,
484: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || D.USER_DELIVERY),
485: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),
486: S.SEGMENT20),S.SEGMENT20),

Line 517: MTL_SYSTEM_ITEMS S,

513: l_item_type,
514: 'N',
515: 'N'
516: from MTL_DEMAND D,
517: MTL_SYSTEM_ITEMS S,
518: BOM_PARAMETERS P,
519: MTL_SALES_ORDERS L,
520: SO_LINES_ALL SL,
521: FND_ID_FLEX_SEGMENTS FS,

Line 592: dupl_total_stmt := 'select I.inventory_item_id,I.organization_id from mtl_system_items_interface I where I.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I.organization_id = :org_buf';

588: LOOP
589: /* ATOPUTIL.info('Starting dupl_check loop'); */
590: stmt_num := 24;
591:
592: dupl_total_stmt := 'select I.inventory_item_id,I.organization_id from mtl_system_items_interface I where I.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I.organization_id = :org_buf';
593:
594: dupl_total_stmt := dupl_total_stmt || ' ' || 'and exists((select ''exists'' from mtl_system_items S2 where S2.inventory_item_id <> I.inventory_item_id';
595:
596: ind := 0;

Line 594: dupl_total_stmt := dupl_total_stmt || ' ' || 'and exists((select ''exists'' from mtl_system_items S2 where S2.inventory_item_id <> I.inventory_item_id';

590: stmt_num := 24;
591:
592: dupl_total_stmt := 'select I.inventory_item_id,I.organization_id from mtl_system_items_interface I where I.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I.organization_id = :org_buf';
593:
594: dupl_total_stmt := dupl_total_stmt || ' ' || 'and exists((select ''exists'' from mtl_system_items S2 where S2.inventory_item_id <> I.inventory_item_id';
595:
596: ind := 0;
597: stmt_num := 25;
598: for ind in 1..20 loop

Line 663: dupl_total_stmt := dupl_total_stmt || 'select ''exists'' from mtl_system_items_interface I2 where I2.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I2.inventory_item_id <> I.inventory_item_id';

659: ** Prepare cursor to select for duplicate item name check
660: */
661: stmt_num := 27;
662:
663: dupl_total_stmt := dupl_total_stmt || 'select ''exists'' from mtl_system_items_interface I2 where I2.SET_ID = TO_CHAR(USERENV(''SESSIONID'')) and I2.inventory_item_id <> I.inventory_item_id';
664:
665: ind := 0;
666: stmt_num := 28;
667: for ind in 1..20 loop

Line 783: select TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)

779: dbms_sql.close_cursor(dupl_cursor);
780: end if;
781:
782: stmt_num := 37;
783: select TO_CHAR(MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
784: into hold_next_seq
785: from dual;
786:
787: /* ATOPUTIL.info('About to update MSI_Intf'); */

Line 789: table_name := 'UPDATE MTL_SYSTEM_ITEMS_IF ';

785: from dual;
786:
787: /* ATOPUTIL.info('About to update MSI_Intf'); */
788:
789: table_name := 'UPDATE MTL_SYSTEM_ITEMS_IF ';
790: stmt_num := 40;
791: update MTL_SYSTEM_ITEMS_INTERFACE I
792: set (SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5,
793: SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10,

Line 791: update MTL_SYSTEM_ITEMS_INTERFACE I

787: /* ATOPUTIL.info('About to update MSI_Intf'); */
788:
789: table_name := 'UPDATE MTL_SYSTEM_ITEMS_IF ';
790: stmt_num := 40;
791: update MTL_SYSTEM_ITEMS_INTERFACE I
792: set (SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5,
793: SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10,
794: SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15,
795: SEGMENT16, SEGMENT17, SEGMENT18, SEGMENT19, SEGMENT20)

Line 997: from MTL_SYSTEM_ITEMS_INTERFACE I2,

993: 3, DECODE(D.USER_DELIVERY, NULL,
994: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || TO_CHAR(hold_next_seq),
995: L.SEGMENT1|| ci_del || D.USER_LINE_NUM ||ci_del|| D.USER_DELIVERY || ci_del ||
996: TO_CHAR(hold_next_seq)), S.SEGMENT20),S.SEGMENT20)
997: from MTL_SYSTEM_ITEMS_INTERFACE I2,
998: MTL_SYSTEM_ITEMS S,
999: BOM_PARAMETERS P,
1000: MTL_SALES_ORDERS L,
1001: MTL_DEMAND D,

Line 998: MTL_SYSTEM_ITEMS S,

994: L.SEGMENT1|| ci_del || D.USER_LINE_NUM || ci_del || TO_CHAR(hold_next_seq),
995: L.SEGMENT1|| ci_del || D.USER_LINE_NUM ||ci_del|| D.USER_DELIVERY || ci_del ||
996: TO_CHAR(hold_next_seq)), S.SEGMENT20),S.SEGMENT20)
997: from MTL_SYSTEM_ITEMS_INTERFACE I2,
998: MTL_SYSTEM_ITEMS S,
999: BOM_PARAMETERS P,
1000: MTL_SALES_ORDERS L,
1001: MTL_DEMAND D,
1002: FND_ID_FLEX_SEGMENTS FS,

Line 1153: MTL_SYSTEM_ITEMS_INTERFACE SI

1149: C.ATTRIBUTE15
1150: from
1151: MTL_PARAMETERS M,
1152: CST_ITEM_COSTS C,
1153: MTL_SYSTEM_ITEMS_INTERFACE SI
1154: where M.ORGANIZATION_ID = SI.ORGANIZATION_ID+0
1155: and C.ORGANIZATION_ID = M.ORGANIZATION_ID
1156: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
1157: and C.COST_TYPE_ID = M.primary_cost_method

Line 1255: MTL_SYSTEM_ITEMS_INTERFACE SI

1251: C.ATTRIBUTE15
1252: from
1253: MTL_PARAMETERS M,
1254: CST_ITEM_COST_DETAILS C,
1255: MTL_SYSTEM_ITEMS_INTERFACE SI
1256: where M.ORGANIZATION_ID = SI.ORGANIZATION_ID+0
1257: and C.ORGANIZATION_ID = M.ORGANIZATION_ID
1258: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
1259: and C.COST_TYPE_ID = M.primary_cost_method

Line 1289: from MTL_SYSTEM_ITEMS_INTERFACE SI,

1285: 1, /* LAST_UPDATE_LOGIN */
1286: D.ELEMENT_VALUE, /* ELEMENT_VALUE */
1287: E.DEFAULT_ELEMENT_FLAG, /* DEFAULT_ELEMENT_FLAG */
1288: E.ELEMENT_SEQUENCE /* ELEMENT_SEQUENCE */
1289: from MTL_SYSTEM_ITEMS_INTERFACE SI,
1290: MTL_DESCR_ELEMENT_VALUES D,
1291: MTL_DESCRIPTIVE_ELEMENTS E
1292: where D.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
1293: and E.ITEM_CATALOG_GROUP_ID = SI.ITEM_CATALOG_GROUP_ID