DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_SECONDARY_INVENTORIES

Line 528: FROM MTL_SECONDARY_INVENTORIES

524: end if;
525: end if;
526: SELECT *
527: INTO p_sub
528: FROM MTL_SECONDARY_INVENTORIES
529: WHERE ORGANIZATION_ID = p_org.organization_id
530: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
531:
532: RETURN T;

Line 949: FROM MTL_SECONDARY_INVENTORIES

945: end if;
946:
947: SELECT *
948: INTO p_sub
949: FROM MTL_SECONDARY_INVENTORIES
950: WHERE ORGANIZATION_ID = p_org.organization_id
951: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
952: RETURN T;
953:

Line 2746: FROM mtl_secondary_inventories

2742: END IF;
2743:
2744: SELECT *
2745: INTO p_sub
2746: FROM mtl_secondary_inventories
2747: WHERE secondary_inventory_name = p_sub.secondary_inventory_name
2748: AND organization_id = p_org.organization_id
2749: AND NVL(disable_date,sysdate+1) > sysdate;
2750:

Line 2794: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi

2790: END IF;
2791:
2792: SELECT msi.*
2793: INTO p_sub
2794: FROM mtl_secondary_inventories msi,mtl_item_sub_inventories misi
2795: WHERE msi.secondary_inventory_name = p_sub.secondary_inventory_name
2796: AND msi.organization_id = p_org.organization_id
2797: AND NVL(MSI.DISABLE_DATE,SYSDATE) >= SYSDATE
2798: AND msi.organization_id = misi.organization_id