APPS.CSD_WIP_JOB_PVT dependencies on WIP_OPERATIONS

Line 649: FROM wip_operations

645: -- cursor to fetch the default operation sequence number
646:
647: CURSOR default_operation(p_wip_entity_id IN NUMBER) IS
648: SELECT operation_seq_num
649: FROM wip_operations
650: WHERE wip_entity_id = p_wip_entity_id AND
651: previous_operation_seq_num IS NULL ;
652:
653: -- special case ( when CSD: Default Repair Item as Material on Job profile is set to yes)

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

905: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
906:
907:
908: Cursor c_get_min_operation_seq(p_wip_entity_id number) is
909: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
910:
911: l_inventory_item_id NUMBER;
912: l_unit_of_measure VARCHAR2(3);
913: l_quantity NUMBER;