DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_SERIAL_TAGGING_ASSIGNMENTS

Line 686: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments

682: END IF;
683: BEGIN
684: SELECT 2 INTO x_serial_tag
685: FROM DUAL
686: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
687: WHERE organization_id = p_organization_id
688: AND inventory_item_id = p_inventory_item_id
689: AND transaction_type_id = l_txn_type
690: );