APPS.INV_VALIDATE dependencies on MTL_SECONDARY_INVENTORIES

Line 522: FROM MTL_SECONDARY_INVENTORIES

518: end if;
519: end if;
520: SELECT *
521: INTO p_sub
522: FROM MTL_SECONDARY_INVENTORIES
523: WHERE ORGANIZATION_ID = p_org.organization_id
524: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
525:
526: RETURN T;

Line 943: FROM MTL_SECONDARY_INVENTORIES

939: end if;
940:
941: SELECT *
942: INTO p_sub
943: FROM MTL_SECONDARY_INVENTORIES
944: WHERE ORGANIZATION_ID = p_org.organization_id
945: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
946: RETURN T;
947:

Line 2612: FROM mtl_secondary_inventories

2608: END IF;
2609:
2610: SELECT *
2611: INTO p_sub
2612: FROM mtl_secondary_inventories
2613: WHERE secondary_inventory_name = p_sub.secondary_inventory_name
2614: AND organization_id = p_org.organization_id
2615: AND NVL(disable_date,sysdate+1) > sysdate;
2616:

Line 2660: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi

2656: END IF;
2657:
2658: SELECT msi.*
2659: INTO p_sub
2660: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi
2661: WHERE msi.secondary_inventory_name = p_sub.secondary_inventory_name
2662: AND msi.organization_id = p_org.organization_id
2663: AND NVL(MSI.DISABLE_DATE,SYSDATE) >= SYSDATE
2664: AND msi.organization_id = misi.organization_id