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.INV_UI_ITEM_LOVS dependencies on WMS_DEPLOY

Line 62: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'

58: || 'null, '
59: || '''N'', '
60: || 'inventory_item_flag, '
61: || '0,'
62: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'
63: || 'inventory_asset_flag,'
64: || 'outside_operation_flag,'
65: --Bug No 3952081
66: --Additional Fields for Process Convergence

Line 110: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'

106: || 'mcr.cross_reference, '
107: || '''N'', '
108: || 'inventory_item_flag, '
109: || '0,'
110: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'
111: || 'inventory_asset_flag,'
112: || 'outside_operation_flag,'
113: --Bug No 3952081
114: --Additional Fields for Process Convergence

Line 141: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

137: -- Bug 4997004 sql Id 14813260 End
138: BEGIN
139: l_where_clause := p_where_clause;
140:
141: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
142:
143: -- Modified for Bug # 5472330
144: -- Changed mtl_system_items_kfv to mtl_system_items_vl
145:

Line 204: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'

200: || 'null, '
201: || '''N'', '
202: || ' msik.inventory_item_flag, '
203: || '0,'
204: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'
205: || ' msik.inventory_asset_flag,'
206: || ' msik.outside_operation_flag,'
207: --Bug No 3952081
208: --Additional Fields for Process Convergence

Line 249: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'

245: || 'null, '
246: || '''N'', '
247: || ' msik.inventory_item_flag, '
248: || '0,'
249: || 'wms_deploy.get_item_client_name(msik.inventory_item_id),'
250: || ' msik.inventory_asset_flag,'
251: || ' msik.outside_operation_flag,'
252: --Additional Fields for Process Convergence
253: || 'NVL(msik.GRADE_CONTROL_FLAG,''N''),'

Line 274: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

270: BEGIN
271: --Bug8791294 changed where clause added OR to check locatorid from MIL
272: --bug9758224 separated "moqd.locator id = ... OR locator_id in" into 2 separate selects union all'ed together
273: l_where_clause := p_where_clause;
274: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
275:
276: IF (p_locator_id IS NOT NULL ) THEN
277: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */
278: || ''' AND moqd.locator_id = ' || p_locator_id ||'

Line 351: l_Concatenated_Segments:=l_Concatenated_Segments||wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

347:
348: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
349:
350: if l_Concatenated_Segments is not null then
351: l_Concatenated_Segments:=l_Concatenated_Segments||wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
352: end if;
353:
354:
355: OPEN x_items FOR

Line 381: wms_deploy.get_item_client_name(inventory_item_id),

377: '',
378: 'N',
379: inventory_item_flag,
380: 0,
381: wms_deploy.get_item_client_name(inventory_item_id),
382: --Bug No 3952081
383: --Additional Fields for Process Convergence
384: NVL(GRADE_CONTROL_FLAG,'N'),
385: NVL(DEFAULT_GRADE,''),

Line 433: wms_deploy.get_item_client_name(msik.inventory_item_id),

429: mcr.cross_reference,
430: 'N',
431: inventory_item_flag,
432: 0,
433: wms_deploy.get_item_client_name(msik.inventory_item_id),
434: --Bug No 3952081
435: --Additional Fields for Process Convergence
436: NVL(GRADE_CONTROL_FLAG,'N'),
437: NVL(DEFAULT_GRADE,''),

Line 471: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

467: BEGIN
468: --Bug 2769632 Modified the sub query so that invalid combinations of lot/serial and revision items are not visible in the LOV
469: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
470:
471: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
472:
473: OPEN x_items FOR
474: SELECT msik.concatenated_segments
475: , msik.inventory_item_id

Line 499: , wms_deploy.get_item_client_name(msik.inventory_item_id),

495: , ''
496: , 'N'
497: , msik.inventory_item_flag
498: , 0
499: , wms_deploy.get_item_client_name(msik.inventory_item_id),
500: --Bug No 3952081
501: --Additional Fields for Process Convergence
502: NVL(msik.GRADE_CONTROL_FLAG,'N'),
503: NVL(msik.DEFAULT_GRADE,''),

Line 563: , wms_deploy.get_item_client_name(msik.inventory_item_id),

559: , mcr.cross_reference
560: , 'N'
561: , inventory_item_flag
562: , 0
563: , wms_deploy.get_item_client_name(msik.inventory_item_id),
564: --Bug No 3952081
565: --Additional Fields for Process Convergence
566: NVL(GRADE_CONTROL_FLAG,'N'),
567: NVL(DEFAULT_GRADE,''),

Line 829: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

825: l_append varchar2(2):='';
826: BEGIN
827:
828: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
829: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
830:
831: IF p_transaction_type_id = inv_globals.g_type_inv_lot_split -- Lot Split (82)
832: THEN
833: OPEN x_items FOR

Line 1926: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),'

1922: || ', '''''
1923: || ', ''N'''
1924: || ', msik.inventory_item_flag'
1925: || ', 0'
1926: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),'
1927: --Bug No 3952081
1928: --Additional Fields for Process Convergence
1929: || 'NVL(msik.GRADE_CONTROL_FLAG,''N''),'
1930: || 'NVL(msik.DEFAULT_GRADE,''''),'

Line 1972: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),'

1968: || ', mcr.cross_reference'
1969: || ', ''N'''
1970: || ', msik.inventory_item_flag'
1971: || ', 0'
1972: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),'
1973: --Bug No 3952081
1974: --Additional Fields for Process Convergence
1975: || 'NVL(msik.GRADE_CONTROL_FLAG,''N''),'
1976: || 'NVL(msik.DEFAULT_GRADE,''''),'

Line 1995: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

1991: BEGIN
1992:
1993: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
1994:
1995: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
1996:
1997: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'
1998: || ' WHERE msik.concatenated_segments LIKE (''' || p_concatenated_segments ||l_append|| ''')'
1999: || ' AND msik.organization_id = ' || p_organization_id

Line 2043: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

2039: BEGIN
2040:
2041: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
2042:
2043: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
2044:
2045: OPEN x_items FOR
2046: SELECT DISTINCT msik.concatenated_segments concatenated_segments
2047: , msik.inventory_item_id

Line 2071: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2067: , ''
2068: , 'N'
2069: , msik.inventory_item_flag
2070: , 0
2071: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2072: --Bug No 3952081
2073: --Additional Fields for Process Convergence
2074: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2075: NVL(msik.DEFAULT_GRADE,''),

Line 2129: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2125: , mcr.cross_reference
2126: , 'N'
2127: , msik.inventory_item_flag
2128: , 0
2129: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2130: --Bug No 3952081
2131: --Additional Fields for Process Convergence
2132: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2133: NVL(msik.DEFAULT_GRADE,''),

Line 2203: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

2199: BEGIN
2200:
2201: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
2202:
2203: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
2204:
2205: IF (p_dynamic_entry_flag = 1) THEN -- Dynamic entries are allowed
2206: OPEN x_items FOR
2207: SELECT concatenated_segments

Line 2232: , wms_deploy.get_item_client_name(inventory_item_id),

2228: , ''
2229: , 'N'
2230: , inventory_item_flag
2231: , 0
2232: , wms_deploy.get_item_client_name(inventory_item_id),
2233: --Bug No 3952081
2234: --Additional Fields for Process Convergence
2235: NVL(GRADE_CONTROL_FLAG,'N'),
2236: NVL(DEFAULT_GRADE,''),

Line 2294: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2290: , mcr.cross_reference
2291: , 'N'
2292: , inventory_item_flag
2293: , 0
2294: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2295: --Bug No 3952081
2296: --Additional Fields for Process Convergence
2297: NVL(GRADE_CONTROL_FLAG,'N'),
2298: NVL(DEFAULT_GRADE,''),

Line 2351: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2347: , ''
2348: , 'N'
2349: , msik.inventory_item_flag
2350: , 0
2351: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2352: --Bug No 3952081
2353: --Additional Fields for Process Convergence
2354: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2355: NVL(msik.DEFAULT_GRADE,''),

Line 2423: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2419: , mcr.cross_reference
2420: , 'N'
2421: , msik.inventory_item_flag
2422: , 0
2423: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2424: --Bug No 3952081
2425: --Additional Fields for Process Convergence
2426: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2427: NVL(msik.DEFAULT_GRADE,''),

Line 2579: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

2575: l_append varchar2(2):='';
2576: BEGIN
2577:
2578: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
2579: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
2580: OPEN x_items FOR
2581: SELECT DISTINCT concatenated_segments
2582: , inventory_item_id
2583: , description

Line 2606: , wms_deploy.get_item_client_name(inventory_item_id),

2602: , ''
2603: , 'N'
2604: , inventory_item_flag
2605: , 0
2606: , wms_deploy.get_item_client_name(inventory_item_id),
2607: inventory_asset_flag, --5591433: Added inventory_asset_flag and outside_processing_flag.
2608: outside_operation_flag,
2609: --Bug No 3952081
2610: --Additional Fields for Process Convergence

Line 2662: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2658: , mcr.cross_reference
2659: , 'N'
2660: , inventory_item_flag
2661: , 0
2662: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2663: inventory_asset_flag, --5591433: Added inventory_asset_flag and outside_processing_flag.
2664: outside_operation_flag,
2665: --Bug No 3952081
2666: --Additional Fields for Process Convergence

Line 2736: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

2732: BEGIN
2733:
2734: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
2735:
2736: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
2737:
2738: -- Get the cycle count discrepancy option flags
2739: SELECT NVL(serial_discrepancy_option, 2)
2740: , NVL(container_discrepancy_option, 2)

Line 2780: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2776: , ''
2777: , 'N'
2778: , msik.inventory_item_flag
2779: , 0
2780: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2781: --Bug No 3952081
2782: --Additional Fields for Process Convergence
2783: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2784: NVL(msik.DEFAULT_GRADE,''),

Line 2847: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2843: , mcr.cross_reference
2844: , 'N'
2845: , msik.inventory_item_flag
2846: , 0
2847: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2848: --Bug No 3952081
2849: --Additional Fields for Process Convergence
2850: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2851: NVL(msik.DEFAULT_GRADE,''),

Line 2910: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2906: , ''
2907: , 'N'
2908: , msik.inventory_item_flag
2909: , 0
2910: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2911: --Bug No 3952081
2912: --Additional Fields for Process Convergence
2913: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2914: NVL(msik.DEFAULT_GRADE,''),

Line 2983: , wms_deploy.get_item_client_name(msik.inventory_item_id),

2979: , mcr.cross_reference
2980: , 'N'
2981: , msik.inventory_item_flag
2982: , 0
2983: , wms_deploy.get_item_client_name(msik.inventory_item_id),
2984: --Bug No 3952081
2985: --Additional Fields for Process Convergence
2986: NVL(msik.GRADE_CONTROL_FLAG,'N'),
2987: NVL(msik.DEFAULT_GRADE,''),

Line 3151: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

3147: l_append varchar2(2):='';
3148: BEGIN
3149:
3150: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
3151: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
3152:
3153: IF (p_concatenated_segments IS NOT NULL
3154: AND p_concatenated_segments <> '%') THEN
3155: OPEN x_items FOR

Line 3182: , wms_deploy.get_item_client_name(a.inventory_item_id),

3178: , ''
3179: , 'N'
3180: , a.inventory_item_flag
3181: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty --BUG12820609
3182: , wms_deploy.get_item_client_name(a.inventory_item_id),
3183: --Bug No 3952081
3184: --Additional Fields for Process Convergence
3185: NVL(a.GRADE_CONTROL_FLAG,'N'),
3186: NVL(a.DEFAULT_GRADE,''),

Line 3241: , wms_deploy.get_item_client_name(a.inventory_item_id),

3237: , mcr.cross_reference
3238: , 'N'
3239: , a.inventory_item_flag
3240: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3241: , wms_deploy.get_item_client_name(a.inventory_item_id),
3242: --Bug No 3952081
3243: --Additional Fields for Process Convergence
3244: NVL(a.GRADE_CONTROL_FLAG,'N'),
3245: NVL(a.DEFAULT_GRADE,''),

Line 3307: , wms_deploy.get_item_client_name(a.inventory_item_id),

3303: , ''
3304: , 'N'
3305: , a.inventory_item_flag
3306: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3307: , wms_deploy.get_item_client_name(a.inventory_item_id),
3308: --Bug No 3952081
3309: --Additional Fields for Process Convergence
3310: NVL(a.GRADE_CONTROL_FLAG,'N'),
3311: NVL(a.DEFAULT_GRADE,''),

Line 3367: , wms_deploy.get_item_client_name(a.inventory_item_id),

3363: , ''
3364: , 'N'
3365: , a.inventory_item_flag
3366: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('LPN', p_lpn_id, NULL, NULL, p_organization_id, b.inventory_item_id, a.primary_uom_code)) insp_qty
3367: , wms_deploy.get_item_client_name(a.inventory_item_id),
3368: --Bug No 3952081
3369: --Additional Fields for Process Convergence
3370: NVL(a.GRADE_CONTROL_FLAG,'N'),
3371: NVL(a.DEFAULT_GRADE,''),

Line 3440: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

3436: l_append varchar2(2):='';
3437: BEGIN
3438:
3439: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
3440: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
3441:
3442: IF (p_container_item_flag IS NULL) THEN
3443: OPEN x_items FOR
3444: SELECT DISTINCT msi.concatenated_segments

Line 3469: , wms_deploy.get_item_client_name(moq.inventory_item_id),

3465: , ''
3466: , 'N'
3467: , msi.inventory_item_flag
3468: , 0
3469: , wms_deploy.get_item_client_name(moq.inventory_item_id),
3470: --Bug No 3952081
3471: --Additional Fields for Process Convergence
3472: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3473: NVL(msi.DEFAULT_GRADE,''),

Line 3525: , wms_deploy.get_item_client_name(moq.inventory_item_id),

3521: , mcr.cross_reference
3522: , 'N'
3523: , msi.inventory_item_flag
3524: , 0
3525: , wms_deploy.get_item_client_name(moq.inventory_item_id),
3526: --Bug No 3952081
3527: --Additional Fields for Process Convergence
3528: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3529: NVL(msi.DEFAULT_GRADE,''),

Line 3587: , wms_deploy.get_item_client_name(moq.inventory_item_id),

3583: , ''
3584: , 'N'
3585: , msi.inventory_item_flag
3586: , 0
3587: , wms_deploy.get_item_client_name(moq.inventory_item_id),
3588: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3589: --Bug No 3952081
3590: --Additional Fields for Process Convergence
3591: NVL(msi.DEFAULT_GRADE,''),

Line 3644: , wms_deploy.get_item_client_name(moq.inventory_item_id),

3640: , mcr.cross_reference
3641: , 'N'
3642: , msi.inventory_item_flag
3643: , 0
3644: , wms_deploy.get_item_client_name(moq.inventory_item_id),
3645: --Bug No 3952081
3646: --Additional Fields for Process Convergence
3647: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3648: NVL(msi.DEFAULT_GRADE,''),

Line 3687: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

3683: l_append varchar2(2):='';
3684: BEGIN
3685:
3686: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
3687: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
3688:
3689: OPEN x_items FOR
3690: SELECT DISTINCT msi.concatenated_segments
3691: , wlc.inventory_item_id

Line 3715: , wms_deploy.get_item_client_name(wlc.inventory_item_id),

3711: , ''
3712: , 'N'
3713: , msi.inventory_item_flag
3714: , 0
3715: , wms_deploy.get_item_client_name(wlc.inventory_item_id),
3716: --Bug No 3952081
3717: --Additional Fields for Process Convergence
3718: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3719: NVL(msi.DEFAULT_GRADE,''),

Line 3769: , wms_deploy.get_item_client_name(wlc.inventory_item_id),

3765: , mcr.cross_reference
3766: , 'N'
3767: , msi.inventory_item_flag
3768: , 0
3769: , wms_deploy.get_item_client_name(wlc.inventory_item_id),
3770: --Bug No 3952081
3771: --Additional Fields for Process Convergence
3772: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3773: NVL(msi.DEFAULT_GRADE,''),

Line 3810: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

3806: l_append varchar2(2):='';
3807: BEGIN
3808:
3809: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
3810: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
3811:
3812: IF (NVL(p_source, '1') = '1') THEN
3813: IF (p_container_item_flag = 'Y') THEN
3814: OPEN x_items FOR

Line 3840: , wms_deploy.get_item_client_name(msi.inventory_item_id),

3836: , ''
3837: , 'N'
3838: , msi.inventory_item_flag
3839: , 0
3840: , wms_deploy.get_item_client_name(msi.inventory_item_id),
3841: --Bug No 3952081
3842: --Additional Fields for Process Convergence
3843: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3844: NVL(msi.DEFAULT_GRADE,''),

Line 3893: , wms_deploy.get_item_client_name(msi.inventory_item_id),

3889: , mcr.cross_reference
3890: , 'N'
3891: , msi.inventory_item_flag
3892: , 0
3893: , wms_deploy.get_item_client_name(msi.inventory_item_id),
3894: --Bug No 3952081
3895: --Additional Fields for Process Convergence
3896: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3897: NVL(msi.DEFAULT_GRADE,''),

Line 3951: , wms_deploy.get_item_client_name(msi.inventory_item_id),

3947: , ''
3948: , 'N'
3949: , msi.inventory_item_flag
3950: , 0
3951: , wms_deploy.get_item_client_name(msi.inventory_item_id),
3952: --Bug No 3952081
3953: --Additional Fields for Process Convergence
3954: NVL(msi.GRADE_CONTROL_FLAG,'N'),
3955: NVL(msi.DEFAULT_GRADE,''),

Line 4009: , wms_deploy.get_item_client_name(msi.inventory_item_id),

4005: , mcr.cross_reference
4006: , 'N'
4007: , msi.inventory_item_flag
4008: , 0
4009: , wms_deploy.get_item_client_name(msi.inventory_item_id),
4010: --Bug No 3952081
4011: --Additional Fields for Process Convergence
4012: NVL(msi.GRADE_CONTROL_FLAG,'N'),
4013: NVL(msi.DEFAULT_GRADE,''),

Line 4074: , wms_deploy.get_item_client_name(inventory_item_id),

4070: , ''
4071: , 'N'
4072: , inventory_item_flag
4073: , 0
4074: , wms_deploy.get_item_client_name(inventory_item_id),
4075: --Bug No 3952081
4076: --Additional Fields for Process Convergence
4077: NVL(GRADE_CONTROL_FLAG,'N'),
4078: NVL(DEFAULT_GRADE,''),

Line 4127: , wms_deploy.get_item_client_name(msik.inventory_item_id),

4123: , mcr.cross_reference
4124: , 'N'
4125: , inventory_item_flag
4126: , 0
4127: , wms_deploy.get_item_client_name(msik.inventory_item_id),
4128: --Bug No 3952081
4129: --Additional Fields for Process Convergence
4130: NVL(GRADE_CONTROL_FLAG,'N'),
4131: NVL(DEFAULT_GRADE,''),

Line 4232: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

4228: BEGIN
4229:
4230: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
4231:
4232: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
4233:
4234: IF (p_source IN ('PO', 'po')) THEN
4235: OPEN x_items FOR
4236: SELECT DISTINCT a.concatenated_segments

Line 4261: , wms_deploy.get_item_client_name(a.inventory_item_id)

4257: , ''
4258: , 'N'
4259: , a.inventory_item_flag
4260: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4261: , wms_deploy.get_item_client_name(a.inventory_item_id)
4262: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4263: , a.outside_operation_flag,
4264: --Bug No 3952081
4265: --Additional Fields for Process Convergence

Line 4327: , wms_deploy.get_item_client_name(a.inventory_item_id)

4323: , mcr.cross_reference
4324: , 'N'
4325: , a.inventory_item_flag
4326: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4327: , wms_deploy.get_item_client_name(a.inventory_item_id)
4328: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4329: , a.outside_operation_flag,
4330: --Bug No 3952081
4331: --Additional Fields for Process Convergence

Line 4392: , wms_deploy.get_item_client_name(a.inventory_item_id)

4388: , ''
4389: , 'N'
4390: , a.inventory_item_flag
4391: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4392: , wms_deploy.get_item_client_name(a.inventory_item_id)
4393: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4394: , a.outside_operation_flag,
4395: --Bug No 3952081
4396: --Additional Fields for Process Convergence

Line 4453: , wms_deploy.get_item_client_name(a.inventory_item_id)

4449: , mcr.cross_reference
4450: , 'N'
4451: , a.inventory_item_flag
4452: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4453: , wms_deploy.get_item_client_name(a.inventory_item_id)
4454: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4455: , a.outside_operation_flag,
4456: --Bug No 3952081
4457: --Additional Fields for Process Convergence

Line 4520: , wms_deploy.get_item_client_name(a.inventory_item_id)

4516: , ''
4517: , 'N'
4518: , a.inventory_item_flag
4519: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4520: , wms_deploy.get_item_client_name(a.inventory_item_id)
4521: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4522: , a.outside_operation_flag,
4523: --Bug No 3952081
4524: --Additional Fields for Process Convergence

Line 4581: , wms_deploy.get_item_client_name(a.inventory_item_id)

4577: , mcr.cross_reference
4578: , 'N'
4579: , a.inventory_item_flag
4580: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RMA', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4581: , wms_deploy.get_item_client_name(a.inventory_item_id)
4582: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4583: , a.outside_operation_flag,
4584: --Bug No 3952081
4585: --Additional Fields for Process Convergence

Line 4648: , wms_deploy.get_item_client_name(a.inventory_item_id)

4644: , ''
4645: , 'N'
4646: , a.inventory_item_flag
4647: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4648: , wms_deploy.get_item_client_name(a.inventory_item_id)
4649: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4650: , a.outside_operation_flag,
4651: --Bug No 3952081
4652: --Additional Fields for Process Convergence

Line 4714: , wms_deploy.get_item_client_name(a.inventory_item_id)

4710: , mcr.cross_reference
4711: , 'N'
4712: , a.inventory_item_flag
4713: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT', p_source_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4714: , wms_deploy.get_item_client_name(a.inventory_item_id)
4715: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4716: , a.outside_operation_flag,
4717: --Bug No 3952081
4718: --Additional Fields for Process Convergence

Line 4781: , wms_deploy.get_item_client_name(a.inventory_item_id)

4777: , ''
4778: , 'N'
4779: , a.inventory_item_flag
4780: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4781: , wms_deploy.get_item_client_name(a.inventory_item_id)
4782: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4783: , a.outside_operation_flag,
4784: --Bug No 3952081
4785: --Additional Fields for Process Convergence

Line 4849: , wms_deploy.get_item_client_name(a.inventory_item_id)

4845: , mcr.cross_reference
4846: , 'N'
4847: , a.inventory_item_flag
4848: , (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('INTSHIP', shipment.shipment_header_id, NULL, NULL, p_organization_id, a.inventory_item_id, a.primary_uom_code))
4849: , wms_deploy.get_item_client_name(a.inventory_item_id)
4850: , a.inventory_asset_flag --5405993: Added inventory_asset_flag and outside_processing_flag.
4851: , a.outside_operation_flag,
4852: --Bug No 3952081
4853: --Additional Fields for Process Convergence

Line 4993: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

4989: BEGIN
4990:
4991: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
4992:
4993: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
4994:
4995: IF p_lpn_id IS NULL THEN
4996: OPEN x_items FOR
4997: SELECT DISTINCT msi.concatenated_segments concatenated_segments

Line 5022: , wms_deploy.get_item_client_name(moq.inventory_item_id),

5018: , ''
5019: , 'N'
5020: , msi.inventory_item_flag
5021: , 0
5022: , wms_deploy.get_item_client_name(moq.inventory_item_id),
5023: --Bug No 3952081
5024: --Additional Fields for Process Convergence
5025: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5026: NVL(msi.DEFAULT_GRADE,''),

Line 5075: , wms_deploy.get_item_client_name(moq.inventory_item_id),

5071: , mcr.cross_reference
5072: , 'N'
5073: , msi.inventory_item_flag
5074: , 0
5075: , wms_deploy.get_item_client_name(moq.inventory_item_id),
5076: --Bug No 3952081
5077: --Additional Fields for Process Convergence
5078: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5079: NVL(msi.DEFAULT_GRADE,''),

Line 5136: , wms_deploy.get_item_client_name(wlc.inventory_item_id),

5132: , ''
5133: , 'N'
5134: , msi.inventory_item_flag
5135: , 0
5136: , wms_deploy.get_item_client_name(wlc.inventory_item_id),
5137: --Bug No 3952081
5138: --Additional Fields for Process Convergence
5139: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5140: NVL(msi.DEFAULT_GRADE,''),

Line 5191: , wms_deploy.get_item_client_name(wlc.inventory_item_id),

5187: , mcr.cross_reference
5188: , 'N'
5189: , msi.inventory_item_flag
5190: , 0
5191: , wms_deploy.get_item_client_name(wlc.inventory_item_id),
5192: --Bug No 3952081
5193: --Additional Fields for Process Convergence
5194: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5195: NVL(msi.DEFAULT_GRADE,''),

Line 5251: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

5247: BEGIN
5248:
5249: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
5250:
5251: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
5252:
5253: OPEN x_items FOR
5254: SELECT DISTINCT concatenated_segments
5255: , inventory_item_id

Line 5279: , wms_deploy.get_item_client_name(inventory_item_id),

5275: , ''
5276: , 'N'
5277: , inventory_item_flag
5278: , 0
5279: , wms_deploy.get_item_client_name(inventory_item_id),
5280: --Bug No 3952081
5281: --Additional Fields for Process Convergence
5282: NVL(GRADE_CONTROL_FLAG,'N'),
5283: NVL(DEFAULT_GRADE,''),

Line 5330: , wms_deploy.get_item_client_name(msik.inventory_item_id),

5326: , mcr.cross_reference
5327: , 'N'
5328: , inventory_item_flag
5329: , 0
5330: , wms_deploy.get_item_client_name(msik.inventory_item_id),
5331: --Bug No 3952081
5332: --Additional Fields for Process Convergence
5333: NVL(GRADE_CONTROL_FLAG,'N'),
5334: NVL(DEFAULT_GRADE,''),

Line 5367: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

5363: BEGIN
5364:
5365: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
5366:
5367: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
5368:
5369: OPEN x_items FOR
5370: SELECT DISTINCT msi.concatenated_segments
5371: , msi.inventory_item_id

Line 5395: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5391: , ''
5392: , 'N'
5393: , msi.inventory_item_flag
5394: , 0
5395: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5396: --Bug No 3952081
5397: --Additional Fields for Process Convergence
5398: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5399: NVL(msi.DEFAULT_GRADE,''),

Line 5449: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5445: , mcr.cross_reference
5446: , 'N'
5447: , msi.inventory_item_flag
5448: , 0
5449: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5450: --Bug No 3952081
5451: --Additional Fields for Process Convergence
5452: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5453: NVL(msi.DEFAULT_GRADE,''),

Line 5492: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);

5488: BEGIN
5489:
5490: l_cross_ref := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
5491:
5492: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
5493:
5494: OPEN x_items FOR
5495: SELECT DISTINCT msi.concatenated_segments
5496: , msi.inventory_item_id

Line 5520: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5516: , ''
5517: , 'N'
5518: , msi.inventory_item_flag
5519: , 0
5520: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5521: --Bug No 3952081
5522: --Additional Fields for Process Convergence
5523: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5524: NVL(msi.DEFAULT_GRADE,''),

Line 5572: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5568: , ''
5569: , 'N'
5570: , msi.inventory_item_flag
5571: , 0
5572: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5573: --Bug No 3952081
5574: --Additional Fields for Process Convergence
5575: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5576: NVL(msi.DEFAULT_GRADE,''),

Line 5627: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5623: , mcr.cross_reference
5624: , 'N'
5625: , msi.inventory_item_flag
5626: , 0
5627: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5628: --Bug No 3952081
5629: --Additional Fields for Process Convergence
5630: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5631: NVL(msi.DEFAULT_GRADE,''),

Line 5686: , wms_deploy.get_item_client_name(msi.inventory_item_id),

5682: , mcr.cross_reference
5683: , 'N'
5684: , msi.inventory_item_flag
5685: , 0
5686: , wms_deploy.get_item_client_name(msi.inventory_item_id),
5687: --Bug No 3952081
5688: --Additional Fields for Process Convergence
5689: NVL(msi.GRADE_CONTROL_FLAG,'N'),
5690: NVL(msi.DEFAULT_GRADE,''),

Line 5957: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),' -- Bug9369327

5953: || ', '''''
5954: || ', ''N'''
5955: || ', msik.inventory_item_flag'
5956: || ', 0'
5957: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),' -- Bug9369327
5958: --Bug No 3952081
5959: --Additional Fields for Process Convergence
5960: || 'NVL(msik.GRADE_CONTROL_FLAG,''N''),'
5961: || 'NVL(msik.DEFAULT_GRADE,''''),'

Line 6003: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),' -- Bug9369327

5999: || ', mcr.cross_reference'
6000: || ', ''N'''
6001: || ', msik.inventory_item_flag'
6002: || ', 0'
6003: || ', wms_deploy.get_item_client_name(msik.inventory_item_id),' -- Bug9369327
6004: --Bug No 3952081
6005: --Additional Fields for Process Convergence
6006: || 'NVL(msik.GRADE_CONTROL_FLAG,''N''),'
6007: || 'NVL(msik.DEFAULT_GRADE,''''),'

Line 6026: l_append := wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);

6022: BEGIN
6023:
6024: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
6025:
6026: l_append := wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
6027:
6028:
6029: IF P_LPN IS NULL THEN
6030: