APPS.INV_UI_RCV_LOVS dependencies on WMS_DEPLOY

Line 43: IF (WMS_DEPLOY.wms_deployment_mode='L') THEN --LSP

39: IS
40: l_append varchar2(2):='';
41:
42: BEGIN
43: IF (WMS_DEPLOY.wms_deployment_mode='L') THEN --LSP
44: l_append:='%';
45: END IF;
46: IF p_mobile_form = 'RCVTXN' THEN
47: OPEN x_po_num_lov FOR

Line 100: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP

96:
97: SELECT DISTINCT poh.Segment1 ,
98: poh.po_Header_Id ,
99: poh.Type_LookUp_Code ,
100: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP
101: MO_GLOBAL.get_ou_name(poh.org_id) ,--
102: po_Vendors_sv2.Get_vendor_name_func(poh.Vendor_Id),
103: poh.Vendor_Id ,
104: poh.Vendor_Site_Id ,

Line 170: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP

166:
167: SELECT DISTINCT poh.segment1
168: , poh.po_header_id
169: , poh.type_lookup_code
170: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP
171: , MO_GLOBAL.get_ou_name(poh.org_id) --
172: , PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID)
173: , poh.vendor_id
174: , poh.vendor_site_id

Line 213: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP

209:
210: SELECT DISTINCT poh.segment1
211: , poh.po_header_id
212: , poh.type_lookup_code
213: , wms_deploy.get_po_client_name(poh.po_header_id) --LSP
214: , MO_GLOBAL.get_ou_name(poh.org_id) --
215: , PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID)
216: , poh.vendor_id
217: , poh.vendor_site_id

Line 262: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP

258: */
259: SELECT DISTINCT poh.segment1 ,
260: poh.po_header_id ,
261: poh.type_lookup_code ,
262: wms_deploy.get_po_client_name(poh.po_header_id) ,--LSP
263: MO_GLOBAL.get_ou_name(poh.org_id) ,
264: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) ,
265: poh.vendor_id ,
266: poh.vendor_site_id ,

Line 1505: IF (WMS_DEPLOY.wms_deployment_mode='L') THEN --LSP

1501: -- other than % and the % shouldn't be at the beginning.
1502: -- For Eg. P101% or % or %P101% or %P1%01% or P1%01
1503: -- Based on the variable l_doc_num_passed and parameter p_inventory_item_id
1504: -- the queries have been formed.
1505: IF (WMS_DEPLOY.wms_deployment_mode='L') THEN --LSP
1506: l_append:='%';
1507: END IF;
1508: IF p_doc_number IS NOT NULL THEN
1509: IF l_doc_num_length > 1

Line 1537: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP

1533: meaning FIELD0 ,
1534: poh.segment1 FIELD1 ,
1535: to_char(poh.po_header_id) FIELD2 ,
1536: poh.type_lookup_code FIELD3 ,
1537: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1538: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1539: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1540: to_char(poh.vendor_id) FIELD7 ,
1541: to_char(poh.vendor_site_id) FIELD8 ,

Line 1601: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP

1597: meaning FIELD0 ,
1598: poh.segment1 FIELD1 ,
1599: to_char(poh.po_header_id) FIELD2 ,
1600: poh.type_lookup_code FIELD3 ,
1601: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1602: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1603: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1604: to_char(poh.vendor_id) FIELD7 ,
1605: to_char(poh.vendor_site_id) FIELD8 ,

Line 1691: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

1687: meaning FIELD0 ,
1688: poh.segment1 FIELD1 ,
1689: to_char(poh.po_header_id) FIELD2 ,
1690: poh.type_lookup_code FIELD3 ,
1691: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1692: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1693: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1694: to_char(poh.vendor_id) FIELD7 ,
1695: to_char(poh.vendor_site_id) FIELD8 ,

Line 1750: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP

1746: meaning FIELD0 ,
1747: poh.segment1 FIELD1 ,
1748: to_char(poh.po_header_id) FIELD2 ,
1749: poh.type_lookup_code FIELD3 ,
1750: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4,--LSP
1751: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1752: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1753: to_char(poh.vendor_id) FIELD7 ,
1754: to_char(poh.vendor_site_id) FIELD8 ,

Line 1813: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

1809: meaning FIELD0 ,
1810: poh.segment1 FIELD1 ,
1811: to_char(poh.po_header_id) FIELD2 ,
1812: poh.type_lookup_code FIELD3 ,
1813: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1814: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
1815: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1816: to_char(poh.vendor_id) FIELD7 ,
1817: to_char(poh.vendor_site_id) FIELD8 ,

Line 1881: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

1877: meaning FIELD0 ,
1878: poh.segment1 FIELD1 ,
1879: to_char(poh.po_header_id) FIELD2 ,
1880: poh.type_lookup_code FIELD3 ,
1881: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1882: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
1883: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1884: to_char(poh.vendor_id) FIELD7 ,
1885: to_char(poh.vendor_site_id) FIELD8 ,

Line 1949: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

1945: meaning FIELD0 ,
1946: poh.segment1 FIELD1 ,
1947: to_char(poh.po_header_id) FIELD2 ,
1948: poh.type_lookup_code FIELD3 ,
1949: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
1950: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
1951: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
1952: to_char(poh.vendor_id) FIELD7 ,
1953: to_char(poh.vendor_site_id) FIELD8 ,

Line 2437: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

2433: meaning FIELD0 ,
2434: poh.segment1 FIELD1 ,
2435: to_char(poh.po_header_id) FIELD2 ,
2436: poh.type_lookup_code FIELD3 ,
2437: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2438: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
2439: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2440: to_char(poh.vendor_id) FIELD7 ,
2441: to_char(poh.vendor_site_id) FIELD8 ,

Line 2502: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

2498: meaning FIELD0 ,
2499: poh.segment1 FIELD1 ,
2500: to_char(poh.po_header_id) FIELD2 ,
2501: poh.type_lookup_code FIELD3 ,
2502: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2503: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5, --
2504: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2505: to_char(poh.vendor_id) FIELD7 ,
2506: to_char(poh.vendor_site_id) FIELD8 ,

Line 2584: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP

2580: meaning FIELD0 ,
2581: poh.segment1 FIELD1 ,
2582: to_char(poh.po_header_id) FIELD2 ,
2583: poh.type_lookup_code FIELD3 ,
2584: wms_deploy.get_po_client_name(poh.po_header_id) FIELD4 ,--LSP
2585: MO_GLOBAL.get_ou_name(poh.org_id) FIELD5 , --
2586: PO_VENDORS_SV2.GET_VENDOR_NAME_FUNC(POH.VENDOR_ID) FIELD6 ,
2587: to_char(poh.vendor_id) FIELD7 ,
2588: to_char(poh.vendor_site_id) FIELD8 ,

Line 3321: l_append:=wms_deploy.get_item_suffix_for_lov(p_Concatenated_Segments);

3317: l_append varchar2(2):='';
3318:
3319: BEGIN
3320:
3321: l_append:=wms_deploy.get_item_suffix_for_lov(p_Concatenated_Segments);
3322:
3323: print_debug('p_Organization_Id :'||p_Organization_Id,4);
3324: print_debug('p_Concatenated_Segments :'||p_Concatenated_Segments,4);
3325: print_debug('p_poHeaderID :'||p_poHeaderID,4);

Line 3405: wms_deploy.get_item_client_name(inventory_item_id),

3401: '',
3402: 'N',
3403: inventory_item_flag,
3404: 0,
3405: wms_deploy.get_item_client_name(inventory_item_id),
3406: inventory_asset_flag,
3407: outside_operation_flag,
3408: --Bug 3952081
3409: --Select DUOM Attributes for every Item

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

3492: msi.concatenated_segments,
3493: 'S',
3494: msi.inventory_item_flag,
3495: 0,
3496: wms_deploy.get_item_client_name(msi.inventory_item_id),
3497: msi.inventory_asset_flag,
3498: msi.outside_operation_flag,
3499: --Bug 3952081
3500: --Select DUOM Attributes for every Item

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

3589: msi.concatenated_segments,
3590: 'Y',
3591: msi.inventory_item_flag,
3592: 0,
3593: wms_deploy.get_item_client_name(msi.inventory_item_id),
3594: msi.inventory_asset_flag,
3595: msi.outside_operation_flag,
3596: --Bug 3952081
3597: --Select DUOM Attributes for every Item

Line 3686: wms_deploy.get_item_client_name(pol.item_id),

3682: '',
3683: 'N',
3684: 'N',
3685: 0,
3686: wms_deploy.get_item_client_name(pol.item_id),
3687: to_char(NULL),
3688: 'N' ,
3689: --Bug 3952081
3690: --Select DUOM Attributes for every Item

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

3777: msi.concatenated_segments,
3778: 'C',
3779: msi.inventory_item_flag,
3780: 0,
3781: wms_deploy.get_item_client_name(msi.inventory_item_id),
3782: msi.inventory_asset_flag,
3783: msi.outside_operation_flag,
3784: --Bug 3952081
3785: --Select DUOM Attributes for every Item

Line 3884: wms_deploy.get_item_client_name(pol.item_id),

3880: pol.item_description,
3881: 'Y',
3882: 'N',
3883: 0,
3884: wms_deploy.get_item_client_name(pol.item_id),
3885: to_char(NULL),
3886: 'N' ,
3887: --Bug 3952081
3888: --Select DUOM Attributes for every Item

Line 3982: wms_deploy.get_item_client_name(inventory_item_id),

3978: '',
3979: 'N',
3980: inventory_item_flag,
3981: 0,
3982: wms_deploy.get_item_client_name(inventory_item_id),
3983: inventory_asset_flag,
3984: outside_operation_flag,
3985: --Bug 3952081
3986: --Select DUOM Attributes for every Item

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

4071: msi.concatenated_segments,
4072: 'S',
4073: msi.inventory_item_flag,
4074: 0,
4075: wms_deploy.get_item_client_name(msi.inventory_item_id),
4076: msi.inventory_asset_flag,
4077: msi.outside_operation_flag ,
4078: --Bug 3952081
4079: --Select DUOM Attributes for every Item

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

4168: msi.concatenated_segments,
4169: 'Y',
4170: msi.inventory_item_flag,
4171: 0,
4172: wms_deploy.get_item_client_name(msi.inventory_item_id),
4173: msi.inventory_asset_flag,
4174: msi.outside_operation_flag ,
4175: --Bug 3952081
4176: --Select DUOM Attributes for every Item

Line 4265: wms_deploy.get_item_client_name(pol.item_id),

4261: '',
4262: 'N',
4263: 'N',
4264: 0,
4265: wms_deploy.get_item_client_name(pol.item_id),
4266: to_char(NULL),
4267: 'N' ,
4268: --Bug 3952081
4269: --Select DUOM Attributes for every Item

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

4355: msi.concatenated_segments,
4356: 'C',
4357: msi.inventory_item_flag,
4358: 0,
4359: wms_deploy.get_item_client_name(msi.inventory_item_id),
4360: msi.inventory_asset_flag,
4361: msi.outside_operation_flag,
4362: --Bug 3952081
4363: --Select DUOM Attributes for every Item

Line 4464: wms_deploy.get_item_client_name(pol.item_id),

4460: pol.item_description,
4461: 'Y',
4462: 'N',
4463: 0,
4464: wms_deploy.get_item_client_name(pol.item_id),
4465: to_char(NULL),
4466: 'N' ,
4467: --Bug 3952081
4468: --Select DUOM Attributes for every Item

Line 4574: wms_deploy.get_item_client_name(inventory_item_id),

4570: '',
4571: 'N',
4572: inventory_item_flag,
4573: 0,
4574: wms_deploy.get_item_client_name(inventory_item_id),
4575: inventory_asset_flag,
4576: outside_operation_flag,
4577: --Bug 3952081
4578: --Select DUOM Attributes for every Item

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

4659: msi.concatenated_segments,
4660: 'S',
4661: msi.inventory_item_flag,
4662: 0,
4663: wms_deploy.get_item_client_name(msi.inventory_item_id),
4664: msi.inventory_asset_flag,
4665: msi.outside_operation_flag ,
4666: --Bug 3952081
4667: --Select DUOM Attributes for every Item

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

4755: msi.concatenated_segments,
4756: 'Y',
4757: msi.inventory_item_flag,
4758: 0,
4759: wms_deploy.get_item_client_name(msi.inventory_item_id),
4760: msi.inventory_asset_flag,
4761: msi.outside_operation_flag ,
4762: --Bug 3952081
4763: --Select DUOM Attributes for every Item

Line 4851: wms_deploy.get_item_client_name(pol.item_id),

4847: '',
4848: 'N',
4849: 'N',
4850: 0,
4851: wms_deploy.get_item_client_name(pol.item_id),
4852: to_char(NULL),
4853: 'N' ,
4854: --Bug 3952081
4855: --Select DUOM Attributes for every Item

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

4941: msi.concatenated_segments,
4942: 'C',
4943: msi.inventory_item_flag,
4944: 0,
4945: wms_deploy.get_item_client_name(msi.inventory_item_id),
4946: msi.inventory_asset_flag,
4947: msi.outside_operation_flag,
4948: --Bug 3952081
4949: --Select DUOM Attributes for every Item

Line 5047: wms_deploy.get_item_client_name(pol.item_id),

5043: pol.item_description,
5044: 'Y',
5045: 'N',
5046: 0,
5047: wms_deploy.get_item_client_name(pol.item_id),
5048: to_char(NULL),
5049: 'N' ,
5050: --Bug 3952081
5051: --Select DUOM Attributes for every Item

Line 5144: wms_deploy.get_item_client_name(inventory_item_id),

5140: '',
5141: 'N',
5142: inventory_item_flag,
5143: 0,
5144: wms_deploy.get_item_client_name(inventory_item_id),
5145: inventory_asset_flag,
5146: outside_operation_flag,
5147: --Bug 3952081
5148: --Select DUOM Attributes for every Item

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

5222: msi.concatenated_segments,
5223: 'S',
5224: msi.inventory_item_flag,
5225: 0,
5226: wms_deploy.get_item_client_name(msi.inventory_item_id),
5227: msi.inventory_asset_flag,
5228: msi.outside_operation_flag ,
5229: --Bug 3952081
5230: --Select DUOM Attributes for every Item

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

5311: msi.concatenated_segments,
5312: 'Y',
5313: msi.inventory_item_flag,
5314: 0,
5315: wms_deploy.get_item_client_name(msi.inventory_item_id),
5316: msi.inventory_asset_flag,
5317: msi.outside_operation_flag ,
5318: --Bug 3952081
5319: --Select DUOM Attributes for every Item

Line 5400: wms_deploy.get_item_client_name(pol.item_id),

5396: '',
5397: 'N',
5398: 'N',
5399: 0,
5400: wms_deploy.get_item_client_name(pol.item_id),
5401: to_char(NULL),
5402: 'N' ,
5403: --Bug 3952081
5404: --Select DUOM Attributes for every Item

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

5484: msi.concatenated_segments,
5485: 'C',
5486: msi.inventory_item_flag,
5487: 0,
5488: wms_deploy.get_item_client_name(msi.inventory_item_id),
5489: msi.inventory_asset_flag,
5490: msi.outside_operation_flag,
5491: --Bug 3952081
5492: --Select DUOM Attributes for every Item

Line 5583: wms_deploy.get_item_client_name(pol.item_id),

5579: pol.item_description,
5580: 'Y',
5581: 'N',
5582: 0,
5583: wms_deploy.get_item_client_name(pol.item_id),
5584: to_char(NULL),
5585: 'N' ,
5586: --Bug 3952081
5587: --Select DUOM Attributes for every Item

Line 5673: wms_deploy.get_item_client_name(inventory_item_id),

5669: '',
5670: 'N',
5671: inventory_item_flag,
5672: 0,
5673: wms_deploy.get_item_client_name(inventory_item_id),
5674: inventory_asset_flag,
5675: outside_operation_flag,
5676: --Bug 3952081
5677: --Select DUOM Attributes for every Item

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

5752: msi.concatenated_segments,
5753: 'S',
5754: msi.inventory_item_flag,
5755: 0,
5756: wms_deploy.get_item_client_name(msi.inventory_item_id),
5757: msi.inventory_asset_flag,
5758: msi.outside_operation_flag ,
5759: --Bug 3952081
5760: --Select DUOM Attributes for every Item

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

5840: msi.concatenated_segments,
5841: 'Y',
5842: msi.inventory_item_flag,
5843: 0,
5844: wms_deploy.get_item_client_name(msi.inventory_item_id),
5845: msi.inventory_asset_flag,
5846: msi.outside_operation_flag ,
5847: --Bug 3952081
5848: --Select DUOM Attributes for every Item

Line 5928: wms_deploy.get_item_client_name(pol.item_id),

5924: '',
5925: 'N',
5926: 'N',
5927: 0,
5928: wms_deploy.get_item_client_name(pol.item_id),
5929: to_char(NULL),
5930: 'N' ,
5931: --Bug 3952081
5932: --Select DUOM Attributes for every Item

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

6010: msi.concatenated_segments,
6011: 'C',
6012: msi.inventory_item_flag,
6013: 0,
6014: wms_deploy.get_item_client_name(msi.inventory_item_id),
6015: msi.inventory_asset_flag,
6016: msi.outside_operation_flag,
6017: --Bug 3952081
6018: --Select DUOM Attributes for every Item

Line 6108: wms_deploy.get_item_client_name(pol.item_id),

6104: pol.item_description,
6105: 'Y',
6106: 'N',
6107: 0,
6108: wms_deploy.get_item_client_name(pol.item_id),
6109: to_char(NULL),
6110: 'N' ,
6111: --Bug 3952081
6112: --Select DUOM Attributes for every Item

Line 6199: wms_deploy.get_item_client_name(inventory_item_id),

6195: '',
6196: 'N',
6197: inventory_item_flag,
6198: 0,
6199: wms_deploy.get_item_client_name(inventory_item_id),
6200: inventory_asset_flag,
6201: outside_operation_flag,
6202: --Bug 3952081
6203: --Select DUOM Attributes for every Item

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

6275: msi.concatenated_segments,
6276: 'S',
6277: msi.inventory_item_flag,
6278: 0,
6279: wms_deploy.get_item_client_name(msi.inventory_item_id),
6280: msi.inventory_asset_flag,
6281: msi.outside_operation_flag ,
6282: --Bug 3952081
6283: --Select DUOM Attributes for every Item

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

6362: msi.concatenated_segments,
6363: 'Y',
6364: msi.inventory_item_flag,
6365: 0,
6366: wms_deploy.get_item_client_name(msi.inventory_item_id),
6367: msi.inventory_asset_flag,
6368: msi.outside_operation_flag ,
6369: --Bug 3952081
6370: --Select DUOM Attributes for every Item

Line 6450: wms_deploy.get_item_client_name(pol.item_id),

6446: '',
6447: 'N',
6448: 'N',
6449: 0,
6450: wms_deploy.get_item_client_name(pol.item_id),
6451: to_char(NULL),
6452: 'N' ,
6453: --Bug 3952081
6454: --Select DUOM Attributes for every Item

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

6531: msi.concatenated_segments,
6532: 'C',
6533: msi.inventory_item_flag,
6534: 0,
6535: wms_deploy.get_item_client_name(msi.inventory_item_id),
6536: msi.inventory_asset_flag,
6537: msi.outside_operation_flag,
6538: --Bug 3952081
6539: --Select DUOM Attributes for every Item

Line 6629: wms_deploy.get_item_client_name(pol.item_id),

6625: pol.item_description,
6626: 'Y',
6627: 'N',
6628: 0,
6629: wms_deploy.get_item_client_name(pol.item_id),
6630: to_char(NULL),
6631: 'N' ,
6632: --Bug 3952081
6633: --Select DUOM Attributes for every Item

Line 6733: wms_deploy.get_item_client_name(msn.inventory_item_id),

6729: '',
6730: 'N',
6731: inventory_item_flag,
6732: 0,
6733: wms_deploy.get_item_client_name(msn.inventory_item_id),
6734: inventory_asset_flag,
6735: outside_operation_flag,
6736: --Bug 3952081
6737: --Select DUOM Attributes for every Item

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

6801: msi.concatenated_segments,
6802: 'Y',
6803: msi.inventory_item_flag,
6804: 0,
6805: wms_deploy.get_item_client_name(msi.inventory_item_id),
6806: msi.inventory_asset_flag,
6807: msi.outside_operation_flag ,
6808: --Bug 3952081
6809: --Select DUOM Attributes for every Item

Line 6904: wms_deploy.get_item_client_name(pol.item_id),

6900: '',
6901: 'N',
6902: 'N',
6903: 0,
6904: wms_deploy.get_item_client_name(pol.item_id),
6905: to_char(NULL),
6906: 'N' ,
6907: --Bug 3952081
6908: --Select DUOM Attributes for every Item

Line 6999: wms_deploy.get_item_client_name(msn.inventory_item_id),

6995: msn.concatenated_segments,
6996: 'C',
6997: msn.inventory_item_flag,
6998: 0,
6999: wms_deploy.get_item_client_name(msn.inventory_item_id),
7000: msn.inventory_asset_flag,
7001: msn.outside_operation_flag,
7002: --Bug 3952081
7003: --Select DUOM Attributes for every Item

Line 7076: wms_deploy.get_item_client_name(msn.inventory_item_id),

7072: '',
7073: 'N',
7074: inventory_item_flag,
7075: 0,
7076: wms_deploy.get_item_client_name(msn.inventory_item_id),
7077: inventory_asset_flag,
7078: outside_operation_flag,
7079: --Bug 3952081
7080: --Select DUOM Attributes for every Item

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

7142: msi.concatenated_segments,
7143: 'Y',
7144: msi.inventory_item_flag,
7145: 0,
7146: wms_deploy.get_item_client_name(msi.inventory_item_id),
7147: msi.inventory_asset_flag,
7148: msi.outside_operation_flag ,
7149: --Bug 3952081
7150: --Select DUOM Attributes for every Item

Line 7242: wms_deploy.get_item_client_name(pol.item_id),

7238: '',
7239: 'N',
7240: 'N',
7241: 0,
7242: wms_deploy.get_item_client_name(pol.item_id),
7243: to_char(NULL),
7244: 'N' ,
7245: --Bug 3952081
7246: --Select DUOM Attributes for every Item

Line 7336: wms_deploy.get_item_client_name(msn.inventory_item_id),

7332: msn.concatenated_segments,
7333: 'C',
7334: msn.inventory_item_flag,
7335: 0,
7336: wms_deploy.get_item_client_name(msn.inventory_item_id),
7337: msn.inventory_asset_flag,
7338: msn.outside_operation_flag,
7339: --Bug 3952081
7340: --Select DUOM Attributes for every Item

Line 7422: wms_deploy.get_item_client_name(inventory_item_id),

7418: '',
7419: 'N',
7420: inventory_item_flag,
7421: 0,
7422: wms_deploy.get_item_client_name(inventory_item_id),
7423: inventory_asset_flag,
7424: outside_operation_flag,
7425: --Bug 3952081
7426: --Select DUOM Attributes for every Item

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

7486: msi.concatenated_segments,
7487: 'C',
7488: msi.inventory_item_flag,
7489: 0,
7490: wms_deploy.get_item_client_name(msi.inventory_item_id),
7491: msi.inventory_asset_flag,
7492: msi.outside_operation_flag,
7493: --Bug 3952081
7494: --Select DUOM Attributes for every Item

Line 7578: wms_deploy.get_item_client_name(inventory_item_id),

7574: '' ,
7575: 'N' ,
7576: inventory_item_flag ,
7577: 0 ,
7578: wms_deploy.get_item_client_name(inventory_item_id),
7579: inventory_asset_flag ,
7580: outside_operation_flag ,
7581: --Bug 3952081
7582: --Select DUOM Attributes for every Item

Line 7665: wms_deploy.get_item_client_name(inventory_item_id),

7661: '' ,
7662: 'N' ,
7663: inventory_item_flag ,
7664: 0 ,
7665: wms_deploy.get_item_client_name(inventory_item_id),
7666: inventory_asset_flag ,
7667: outside_operation_flag ,
7668: --Bug 3952081
7669: --Select DUOM Attributes for every Item

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

7742: msi.concatenated_segments ,
7743: 'C' ,
7744: msi.inventory_item_flag ,
7745: 0 ,
7746: wms_deploy.get_item_client_name(msi.inventory_item_id),
7747: msi.inventory_asset_flag ,
7748: msi.outside_operation_flag ,
7749: --Bug 3952081
7750: --Select DUOM Attributes for every Item

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

7867: '',
7868: 'N',
7869: msi.inventory_item_flag,
7870: 0,
7871: wms_deploy.get_item_client_name(msi.inventory_item_id),
7872: msi.inventory_asset_flag,
7873: msi.outside_operation_flag,
7874: --Bug 3952081
7875: --Select DUOM Attributes for every Item

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

7928: '',
7929: 'N',
7930: msi.inventory_item_flag,
7931: 0,
7932: wms_deploy.get_item_client_name(msi.inventory_item_id),
7933: msi.inventory_asset_flag,
7934: msi.outside_operation_flag,
7935: --Bug 3952081
7936: --Select DUOM Attributes for every Item

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

8015: msi.concatenated_segments,
8016: 'Y',
8017: msi.inventory_item_flag,
8018: 0,
8019: wms_deploy.get_item_client_name(msi.inventory_item_id),
8020: msi.inventory_asset_flag,
8021: msi.outside_operation_flag,
8022: --Bug 3952081
8023: --Select DUOM Attributes for every Item

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

8095: msi.concatenated_segments,
8096: 'C',
8097: msi.inventory_item_flag,
8098: 0,
8099: wms_deploy.get_item_client_name(msi.inventory_item_id),
8100: msi.inventory_asset_flag,
8101: msi.outside_operation_flag,
8102: --Bug 3952081
8103: --Select DUOM Attributes for every Item

Line 8167: wms_deploy.get_item_client_name(pol.item_id),

8163: '',
8164: 'N',
8165: 'N',
8166: 0,
8167: wms_deploy.get_item_client_name(pol.item_id),
8168: to_char(NULL),
8169: 'N',
8170: --Bug 3952081
8171: --Select DUOM Attributes for every Item

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

8232: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
8233: l_append varchar2(2):='';
8234: BEGIN
8235:
8236: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
8237:
8238: open x_items for
8239:
8240: select concatenated_segments,

Line 8265: wms_deploy.get_item_client_name(inventory_item_id),

8261: '',
8262: 'N',
8263: inventory_item_flag,
8264: 0,
8265: wms_deploy.get_item_client_name(inventory_item_id),
8266: inventory_asset_flag,
8267: outside_operation_flag,
8268: --Bug 3952081
8269: --Select DUOM Attributes for every Item

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

8315: mcr.cross_reference,
8316: 'N',
8317: inventory_item_flag,
8318: 0,
8319: wms_deploy.get_item_client_name(msik.inventory_item_id),
8320: inventory_asset_flag,
8321: outside_operation_flag,
8322: --Bug 3952081
8323: --Select DUOM Attributes for every Item

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

8551: g_crossref VARCHAR2(40) := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
8552: l_append varchar2(2):='';
8553:
8554: BEGIN
8555: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
8556:
8557: IF (p_receiptNum IS NOT NULL ) THEN
8558:
8559: open x_items for

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

8582: null,
8583: 'N',
8584: inventory_item_flag,
8585: 0,
8586: wms_deploy.get_item_client_name(msik.inventory_item_id),
8587: inventory_asset_flag,
8588: outside_operation_flag,
8589: --Bug 3952081
8590: --Select DUOM Attributes for every Item

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

8642: mcr.cross_reference,
8643: 'N',
8644: inventory_item_flag,
8645: 0,
8646: wms_deploy.get_item_client_name(msik.inventory_item_id),
8647: inventory_asset_flag,
8648: outside_operation_flag,
8649: --Bug No 3952081
8650: --Additional Fields for Process Convergence

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

8710: null,
8711: 'N',
8712: inventory_item_flag,
8713: 0,
8714: wms_deploy.get_item_client_name(msik.inventory_item_id),
8715: inventory_asset_flag,
8716: outside_operation_flag,
8717: --Bug 3952081
8718: --Select DUOM Attributes for every Item

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

8765: mcr.cross_reference,
8766: 'N',
8767: inventory_item_flag,
8768: 0,
8769: wms_deploy.get_item_client_name(msik.inventory_item_id),
8770: inventory_asset_flag,
8771: outside_operation_flag,
8772: --Bug No 3952081
8773: --Additional Fields for Process Convergence

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

8827: null,
8828: 'N',
8829: inventory_item_flag,
8830: 0,
8831: wms_deploy.get_item_client_name(msik.inventory_item_id),
8832: inventory_asset_flag,
8833: outside_operation_flag,
8834: --Bug 3952081
8835: --Select DUOM Attributes for every Item

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

8882: mcr.cross_reference,
8883: 'N',
8884: inventory_item_flag,
8885: 0,
8886: wms_deploy.get_item_client_name(msik.inventory_item_id),
8887: inventory_asset_flag,
8888: outside_operation_flag,
8889: --Bug No 3952081
8890: --Additional Fields for Process Convergence

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

8944: null,
8945: 'N',
8946: inventory_item_flag,
8947: 0,
8948: wms_deploy.get_item_client_name(msik.inventory_item_id),
8949: inventory_asset_flag,
8950: outside_operation_flag,
8951: --Bug 3952081
8952: --Select DUOM Attributes for every Item

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

8999: mcr.cross_reference,
9000: 'N',
9001: inventory_item_flag,
9002: 0,
9003: wms_deploy.get_item_client_name(msik.inventory_item_id),
9004: inventory_asset_flag,
9005: outside_operation_flag,
9006: --Bug No 3952081
9007: --Additional Fields for Process Convergence

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

9062: null,
9063: 'N',
9064: inventory_item_flag,
9065: 0,
9066: wms_deploy.get_item_client_name(msik.inventory_item_id),
9067: inventory_asset_flag,
9068: outside_operation_flag,
9069: --Bug 3952081
9070: --Select DUOM Attributes for every Item

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

9117: mcr.cross_reference,
9118: 'N',
9119: inventory_item_flag,
9120: 0,
9121: wms_deploy.get_item_client_name(msik.inventory_item_id),
9122: inventory_asset_flag,
9123: outside_operation_flag,
9124: --Bug No 3952081
9125: --Additional Fields for Process Convergence

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

9179: null,
9180: 'N',
9181: inventory_item_flag,
9182: 0,
9183: wms_deploy.get_item_client_name(msik.inventory_item_id),
9184: inventory_asset_flag,
9185: outside_operation_flag,
9186: --Bug 3952081
9187: --Select DUOM Attributes for every Item

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

9238: mcr.cross_reference,
9239: 'N',
9240: inventory_item_flag,
9241: 0,
9242: wms_deploy.get_item_client_name(msik.inventory_item_id),
9243: inventory_asset_flag,
9244: outside_operation_flag,
9245: --Bug No 3952081
9246: --Additional Fields for Process Convergence

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

9304: null,
9305: 'N',
9306: inventory_item_flag,
9307: 0,
9308: wms_deploy.get_item_client_name(msik.inventory_item_id),
9309: inventory_asset_flag,
9310: outside_operation_flag,
9311: --Bug 3952081
9312: --Select DUOM Attributes for every Item

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

9359: mcr.cross_reference,
9360: 'N',
9361: inventory_item_flag,
9362: 0,
9363: wms_deploy.get_item_client_name(msik.inventory_item_id),
9364: inventory_asset_flag,
9365: outside_operation_flag,
9366: --Bug No 3952081
9367: --Additional Fields for Process Convergence