DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on WIP_OPERATIONS_V

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

6383: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6384:
6385:
6386: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is
6387: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
6388:
6389: l_inventory_item_id NUMBER;
6390: l_unit_of_measure VARCHAR2(3);
6391: l_quantity NUMBER;

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

7193: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
7194:
7195:
7196: Cursor c_get_min_operation_seq(p_wip_entity_id number) is
7197: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
7198:
7199: l_inventory_item_id NUMBER;
7200: l_unit_of_measure VARCHAR2(3);
7201: l_quantity NUMBER;