DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on DUAL

Line 685: FROM DUAL

681: inv_log_util.TRACE('In branch 1','INV_CACHE',9);
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