DBA Data[Home] [Help]

APPS.BOMPLDCI dependencies on BOMPCFGI

Line 295: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 305: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 315: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 325: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 335: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 345: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 355: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 365: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 375: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 385: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 395: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 405: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 415: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 425: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 435: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 445: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 455: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 465: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 475: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
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,

Line 485: 4, BOMPCFGI.user_item_number(D.INVENTORY_ITEM_ID),

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),
487: 'N', /* ATP_FLAG */
488: S.MRP_PLANNING_CODE, /* MRP_PLANNING_CODE */
489: S.REPETITIVE_PLANNING_FLAG, /* REPETITIVE_PLANNING_FLAG */