APPS.INV_3PL_SEEDED_SOURCES dependencies on WMS_DEPLOY

Line 49: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code

45: as
46:
47: CURSOR items_record(p_client_code VARCHAR2) IS
48: SELECT * FROM mtl_system_items_kfv msib
49: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
50: AND nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
51: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
52: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';
53:

Line 136: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code

132: )
133: as
134: CURSOR items_record(p_client_code VARCHAR2) IS
135: SELECT * FROM mtl_system_items_b msib
136: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
137: and nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
138: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
139: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';
140:

Line 222: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code

218: as
219:
220: CURSOR items_record(p_client_code VARCHAR2) IS
221: SELECT * FROM mtl_system_items_b msib
222: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
223: and nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
224: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
225: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';
226:

Line 314: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code

310:
311: CURSOR items_record(p_client_code VARCHAR2) IS
312: SELECT *
313: FROM mtl_system_items_b msib
314: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
315: AND nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
316: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
317: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';
318:

Line 447: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code

443: as
444:
445: CURSOR items_record(p_client_code VARCHAR2) IS
446: SELECT * FROM mtl_system_items_b msib
447: WHERE wms_deploy.get_client_code(msib.inventory_item_id) = p_client_code
448: and nvl(msib.USAGE_ITEM_FLAG, 'N') = 'N'
449: AND nvl(msib.SERVICE_ITEM_FLAG, 'N') = 'N'
450: AND nvl(msib.VENDOR_WARRANTY_FLAG, 'N') = 'N';
451: