Line 56: * check if any WIP transactions have been performed on the item
52: end if;
53:
54:
55: /* 56: * check if any WIP transactions have been performed on the item 57: */
58: select count(*)
59: into row_count
60: from wip_transactions
Line 60: from wip_transactions
56: * check if any WIP transactions have been performed on the item
57: */
58: select count(*)
59: into row_count 60: from wip_transactions 61: where organization_id = I_ORGANIZATION_ID
62: and primary_item_id = I_INVENTORY_ITEM_ID;
63:
64: if (row_count > 0) then