APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_SYSTEM_ITEMS

Line 824: FROM mtl_system_items msi

820:
821: CURSOR c_item_attributes(v_org_id NUMBER) IS
822: SELECT nvl(msi.RESTRICT_SUBINVENTORIES_CODE,2) restrict_subinventories_code
823: ,nvl(msi.RESTRICT_LOCATORS_CODE,2) restrict_locators_code
824: FROM mtl_system_items msi
825: WHERE msi.inventory_item_id = p_inventory_item_id
826: AND msi.organization_id = v_org_id;
827:
828: l_item_attributes c_item_attributes%ROWTYPE;

Line 4420: FROM mtl_system_items_kfv

4416: Decode(serial_number_control_code,1,'FALSE',6,'FALSE','TRUE')
4417: INTO l_rev_control_code,
4418: l_lot_control_code,
4419: l_serial_control_code
4420: FROM mtl_system_items_kfv
4421: WHERE inventory_item_id = p_inventory_item_id
4422: AND organization_id = p_organization_id;
4423:
4424: IF p_lot_number IS NULL OR p_lot_number = '' THEN

Line 5015: FROM mtl_system_items_b

5011:
5012:
5013: CURSOR c_item_details(v_inventory_item_id NUMBER,v_organization_id NUMBER) IS
5014: SELECT nvl(lot_control_code,1)lot_control_code,nvl(serial_number_control_code,1) serial_number_control_code
5015: FROM mtl_system_items_b
5016: WHERE inventory_item_id = v_inventory_item_id
5017: AND organization_id = v_organization_id;
5018:
5019: CURSOR wopi_cursor(v_source_task_id NUMBER) IS