APPS.INV_3PL_SEEDED_SOURCES dependencies on MTL_SYSTEM_ITEMS_B

Line 135: SELECT * FROM mtl_system_items_b msib

131: x_return_status OUT NOCOPY VARCHAR2
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';

Line 221: SELECT * FROM mtl_system_items_b msib

217: )
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';

Line 313: FROM mtl_system_items_b msib

309: as
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';

Line 446: SELECT * FROM mtl_system_items_b msib

442: )
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';