APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_OPERATIONS_V

Line 5496: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;

5492: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
5493:
5494:
5495: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is
5496: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
5497:
5498: l_inventory_item_id NUMBER;
5499: l_unit_of_measure VARCHAR2(3);
5500: l_quantity NUMBER;

Line 6169: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;

6165: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6166:
6167:
6168: Cursor c_get_min_operation_seq(p_wip_entity_id number) is
6169: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
6170:
6171: l_inventory_item_id NUMBER;
6172: l_unit_of_measure VARCHAR2(3);
6173: l_quantity NUMBER;