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 4377: FROM mtl_system_items_kfv

4373: Decode(serial_number_control_code,1,'FALSE',6,'FALSE','TRUE')
4374: INTO l_rev_control_code,
4375: l_lot_control_code,
4376: l_serial_control_code
4377: FROM mtl_system_items_kfv
4378: WHERE inventory_item_id = p_inventory_item_id
4379: AND organization_id = p_organization_id;
4380:
4381: IF p_lot_number IS NULL OR p_lot_number = '' THEN

Line 4903: FROM mtl_system_items_b

4899:
4900:
4901: CURSOR c_item_details(v_inventory_item_id NUMBER,v_organization_id NUMBER) IS
4902: SELECT nvl(lot_control_code,1)lot_control_code,nvl(serial_number_control_code,1) serial_number_control_code
4903: FROM mtl_system_items_b
4904: WHERE inventory_item_id = v_inventory_item_id
4905: AND organization_id = v_organization_id;
4906:
4907: CURSOR wopi_cursor(v_source_task_id NUMBER) IS